Excel Variance Charts: Actual to Previous Year or Budget Comparisons

Save
2 years ago
30
variance charts chart to show percentage change conditional formatting column charts conditional format bar charts conditinal format data labels excel graphs Best Practices for charts in Excel excel for financial analysts excel charts Data Visualization in Excel Microsoft Excel Tutorials

Mar 31, 2017 Excel Charts
In this video I show you how you can use conditional formatting in Excel Column or Excel Bar charts.

Complete Advanced Excel Chart Course: https://courses.xelplus.com/p/excel-charts-visualization-secrets-for-impressive-charts

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 need to use a different technique. You will need to create two additional series, one for positive number and another for negative numbers and format each series accordingly - and also overlap these by 100%.

Part 2 - Better Variance charts https://rumble.com/v2skmns

Part 3 - Arrow Variance Chart https://rumble.com/v2skmok

Custom formatting is covered in more detail in my online Excel advanced course here: http://www.xelplus.com/onlineAdvancedExcelCourse

★ My Online Excel Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Loading comments...