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

This video is a followup to last week's video on creating a column that displays the percentage change. This iteration has colored error bars to show the positive variances in green and the negative variances in red.

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

The chart is also more dynamic in that it automatically displays the data labels and error bars in the correct position as the data changes. This adds conditional formatting to our chart.

I added a slicer and link the chart's source data to a pivot table using the GETPIVOTDATA function to make the chart fully interactive.

These changes were inspired by questions from Conor and Wayne on last week's video (https://youtu.be/SRTwzaTRfCc).

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 3: https://youtu.be/X0ySDc5KwsM

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:23 Column Chart That Displays Percentage Change or Variance
02:16 Column Chart with percentage Change
03:23 Format Data Series
04:14 Format Error Bars
05:39 Format data labels