Excel Variance Charts: Actual to Previous Year or Budget Comparisons




About this tutorial:

Video duration: 00:14:18
In this video I show you how you can use conditional formatting in Excel Column or Excel Bar charts.

Complete Advanced Excel Chart Course:

I also show you how you can conditionally format the data labels in Excel graphs to show a different color if the values are positive to when the values are negative.

The technique in the video shows a variance column chart but it works in the same way for a bar chart.

This technique works for Excel 2010, Excel 2013 and Excel 2016. For Excel 2007 and below, you…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads