Making Interactive Charts in Excel [How To]

Graphs and charts are amazing tools to understand the information in the blink of an eye. It not only saves you from reading at all levels. That is why charts and Excel is one...

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 loads of fun as we not only understood how to...

10 ways to make Excel Variance Charts – How To

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

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 to mention it one cool way to grab attention at...

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 be investigated and only those should be probed that breach...

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

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

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

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

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