Creating and Working with Dynamic Charts in Excel

Title should be "making charts dance to your command in Excel" but lets keep it technical :) OK let me be very quick at it as I learnt about this almost by chance. I used...

Excel Actual Vs Target – Multi type charts with Subcategory axis and Broken line...

Last time when we learnt about multi-category axis we saw how meaningful chart can become. But today we are going to add in more flavours and ingredients to it and by the end of this...

Highlight instances in Excel charts in different colors with shaded bars in background

Suppose you have a variance chart and want to highlight those that require inquiry. Further suppose that you have two levels of inquiry: Variances that require moderate inquiry (highlighted by for example green color) Variance that require...

Creating Scrollable Charts in Excel [How To]

Last time we discussed on how to have a subset of data within worksheet that scrolls independently and I called it scrollable data ranges. It was fun as we involved one of the Excel...

Creating Timelines in Excel [How To]

Just recently I upgraded the office suit to 2013. And the first thing I did is to see how Excel looks. Its even better. Sublime, simple, to the point and just like the way...

Use Conditional Formatting to make Charts for Excel dashboards

To get the inspiration of better charts and Excel dashboards one must be observant of such pieces of information that are often found in newspapers and internet. For that matter Pinterest and The Economist...

Create Waterfall Charts in Excel – Visualize Income Statements!

A waterfall chart in Excel is a great way to visualize running totals making it super easy to understand how addition and subtraction of values affected starting value and how we reached the final...

Making BCG Matrix in Excel – How To

BCG matrix is a strategic decision making technique that helps in resource allocation among different cost centers or cost objects by categorizing or ranking them based on their ability to generate cash inflows against...

Variance Analysis in Excel – Making better Budget Vs Actual charts

Either it is about daily life or business, we almost all the time in our minds comparing the actual results with our plans. Though we can talk numbers and percentages but the way charts...

Making a Slope Chart or Bump Chart in Excel – How To

Excel has many different styles of charts and graphs inbuilt and one can make them with a single click. A great convenience to have. But for charts and graphs convenience is required, merited and...
12,956FansLike
2,155FollowersFollow
917SubscribersSubscribe