Show Percentage Change (Increase & Decrease) in Column Chart | Show Variance in Excel Chart

Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/05/Percentage-Change-in-Column-Chart.xlsx

In this Microsoft Excel video tutorial I explain how to display percentage change on a column chart. In my example I am plotting monthly sales in a column chart: I want to display the percentage increase or decrease (variance) between months.

00:00 Introduction
00:09 Prepare the data for your chart
00:49 Calculate variance and percent variance
02:39 Start creating the chart
02:52 Format the 'next month revenue' columns
03:28 Display error bars
05:05 Display data labels for the error bars
06:33 Show data labels for the months' revenue values
07:15 Chart formatting tweaks
08:34 Center the month labels in the chart

All enrolments and purchases help this channel (a commission is received at no extra cost to you):

😎5 FREE Excel Templates😎
https://www.simplesheets.co/a/2147506566/v7Aj9zMx

😎Enrol in the Excel University – FREE taster course available😎
https://www.simplesheets.co/a/2147491676/v7Aj9zMx

😎Get 30% Discount on Simple Sheets Templates and Courses
https://www.bluepecantraining.com/simple-sheets-templates/
Use Discount Code BLUE😎

#exceltutorial #exceltips

Видео Show Percentage Change (Increase & Decrease) in Column Chart | Show Variance in Excel Chart канала Chester Tugwell