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

Add a vertical line to Gantt Chart or Stacked Bar Chart in Excel –...

In last tutorial on gantt chart in Excel for project managers we learnt the simplest and fastest way to chart project activities/tasks. Today we are learning how to add a vertical line on the...

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

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

Conditional Charts in Excel – Workaround + How To

Last time we learnt how to make simple dial charts. There is so much to be discussed as basics to Excel charting but without little fun and doing out of ordinary is what everyone...

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

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 Excel charts with Subcategory axis – [Quick Tip]

This is definitely a neat trick. Usually we have single X-axis chart element. But you can have multi-category axis to show the information in a much more arranged manner. Following is what we are after....

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

Make Waffle Charts in Excel using Conditional Formatting – How To

To get the inspiration for better charts and Excel dashboards one must be observant of such pieces of information that are often found in newspapers and the internet. For that matter, Pinterest and The...