10 ways to present variance analysis reports in Excel

Whether it is daily life thing or any day at work, we are always comparing to see whats good and what is not so good. This differential analysis has a much popular name as variance...

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...

Moving X-axis labels at the bottom of the chart below negative values in Excel

By default if you insert a bar chart or line chart, the x-axis labels are stuck at 0 position of the axis. This usual behaviour gets in the way especially if you have negative values...

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...

Budget vs Actual Variance Reports with “In the Cell Charts” in Excel

In life we all want to be in control. And usually we measure or judge whether things under control by comparing whats happening with what should be happening. In other words, we tend compare the actual events/results with...

Dynamically Highlight data points in Excel charts using Form Controls

Charts and graphs and other visual means make information easier to understand and analyze. Excel gives plenty of options in this department as different types of graphs are possible. But in some cases wrong chart types in...

How to show data of hidden rows/columns in Excel Charts

By default if you hide a certain row or column of a data on which a chart is based, Excel will automatically hide that data too. I must confess that I was quite annoyed...

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...

Conditionally Format Chart’s Background in Excel – How To

Excel charting is in the air for last few weeks and we are learning some really cool tricks on making charts better looking and also fulfilling the purpose. Today we will learn how to...

Excel chart of Top / Bottom “N” values using RANK() function and Form controls

Ever fancied that you have large set of data and from it you can have a chart of top or bottom N values and better yet you have the ability to switch between chart...