Enable or Disable Excel Data Labels at the click of a button – How...

Data labels in Excel charts can help users to get the information right at that spot without referring to any other source of information. In some situations however, same data labels can get in...

Excel Chart with highest value in different colour – Multi Color Bar Charts [How...

Reports and charts goes together and the biggest reason to have charts in reports is to add visual treat that makes it super easy for everyone to decide instantly. To toss it even further...

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

Custom Data Labels with Colors and Symbols in Excel Charts – [How To]

Is it possible to have colored data labels like red for negatives and blue or green for positive values inside excel chart? This question was asked by some when I posted Variance Analysis in Excel – Making better...

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 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 and variances (favourable and unfavourable) with arrows so beautifully that...

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

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

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