Make a Bubble Chart in Excel [15 second tutorial]
A Bubble chart displays circles (or bubbles) at given X and Y co-ordinates. Bubble chart is a very good way to show 3 dimensional data (for eg. Region-wise product sales) without confusing users. In this tutorial, we will learn how to create a bubble chart using excel.
Recipe for a Donut Bar Chart
We all know that bar charts can be used to display values spread across various categories or times and pie charts / donut charts can be used to display percentage breakup of various quantities in a sum total. How about mashing up both to create a Donut Bar chart?
In this tutorial, you can learn how to make a donut bar chart and linking it to a form control to display Product-wise sales breakups spread across several years.
Calculate Elapsed Time in Excel [Quick Tips]
Calculating elapsed time is very common whether you are managing a project or raising a baby. Elapsed time is nothing but interval between a starting point and the current point in time. We can use excel formulas to calculate elapsed time very easily. In this post, learn how to calculate elapsed time in days, working days, hours, weeks, months, years, minutes and seconds.
Issue Trackers & Risk Management using Excel [Project Management using Excel – Part 5 of 6]
Tracking issues and risks is where most of the project management time goes. Once the project planning and organizing activities are in good shape, most of the project management activities are around risk management and issue tracking. In this installment of project management using excel, we will learn how to create a simple issue tracker template using excel and how to analyze issues using excel.
Dynamically Grouping Related Events [Excel Combo Charts with Pizzazz]
Yesterday we have posted how to use excel combo charts to group related time events. Today we will learn how to change the event grouping dynamically using form controls.
This effect can be easily achieved with a cup of coffee, one combo box form control and the good old IF formula. Read more to learn how to do this.
Using Combo Charts to Group Related Time Events [Charting Goodness]
In his latest book, Now You See It, on pages 165 and 166 of the book, Stephen Few discusses how grouping related time intervals can facilitate analysis of data. As an illustration he explains that when viewing data of daily website visits, it helps in separating weekdays and weekends to differentiate expected traffic during these periods. The use of this technique would make it easier for the analyst to identify any anomalous movement in ether the weekend or the week day.
Fortunately excel combo charts can help you do that. In this guest post, Paresh explains to us how to do this.
Make a Pivot Table in Excel [15 Second Tutorial]
Last week we have posted a simple to understand excel pivot table tutorial here. Today I am going to supplement the tutorial with a 15 second video tutorial on Making excel pivot tables.