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

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

Better Profit and Loss Statements with Waterfall Charts in Excel

Income statement or Profit or Loss Statements are accountants' everyday job. Whether you are assessing past performance, current or even forecasting, great chances are that you have make this financial statement. It does a pretty...

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

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

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

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

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

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...
12,633FansLike
2,148FollowersFollow