Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

This is the 3rd video in the series on creating a column that displays the percentage change. I share two different techniques submitted by Wayne Edmonson (a member of our VBA Pro Course) and Jon Peltier (my friend and charting master over at PeltierTech.com)

Download the Excel file:
https://www.excelcampus.com/charts/column-chart-percentage-change/

Wayne's solution uses a VBA macro to move the data labels and change their font color as the data changes. This is similar to the solution from video #1, and only uses one invisible bar.

Jon Peltier's solution uses a combo chart with an XY Scatter for the positive and negative series. This eliminates the need for the invisible series, and uses error bars from the data points of the XY instead. Here's a link to Jon Peltier's full article that includes step-by-step instructions.
https://peltiertech.com/revenue-chart-showing-year-over-year-variances/


I love to see how this chart has improved over such a short period of time. I also wanted to share this progression so you can see how our charts won't always be perfect the first time. However, I encourage you to publish them anyways and then be open to feedback from your audience (boss & co-workers).

So please leave a comment with any questions or suggestions below. Thank you for the feedback!


**Excel 2010 & Earlier**
If you are using Excel 2010 or earlier you will not have the Value from Cells option for the data labels. However, you can use the free XY Labeler add-in from AppsPro to create the labels. This will save you a lot of time. Here is the link to download the add-in.
http://www.appspro.com/Utilities/ChartLabeler.htm


Related articles & videos:

Part 1: https://youtu.be/SRTwzaTRfCc
Part 2: https://youtu.be/zaYfih4aOGE

Variance on Clustered Column for Actual versus Budget: https://www.excelcampus.com/charts/variance-clustered-column-bar-chart/

3-part Video Series on Pivot Tables & Dashboards: https://youtu.be/9NUjHBNWe9M

Free Chart Alignment Add-in: https://www.excelcampus.com/keyboard-shortcuts/chart-alignment-add-in/
00:00 Introduction
00:12 Column Chart That Displays Percentage Change or Variance
00:54 Column Chart with Percentage Change
02:05 Macro