Excel Variance Charts: Making Awesome Actual vs Target Or Budget Graphs – How To
In this tutorial we are learning how to make an awesome variance chart in Excel that clearly plots actual and target (budgeted) figures using bars...
Create Excel Charts with Bands or Threshold in the background – [How To]
Just the other day I was teaching my ACCA F5 students about variance analysis and there we learnt that not every variance needs to...
ABC Inventory Analysis using Excel Charts
Earlier this month we learnt how to carry out ABC inventory analysis in Excel using conditional formatting technique. It was easy and we had...
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...
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...
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...
Making Sales Dashboard using Excel Slicers – How To
So many reasons why not to hate Excel dashboards. They are beautiful, they are dynamic, they make everything super easy to understand. And not...
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...
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...
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...