Download the featured file here: [ Ссылка ]

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



#exceltutorial #exceltips

свернуть