# Percentage Change Chart – Excel

This tutorial will demonstrate how to create a Percentage Change Chart in all versions of Excel.

## Percentage Change Chart – Excel

In this example, we’ll start with the graph that shows Revenue for the last 6 years. We want to show changes between each year.

### Copy Year and Revenue

Copy (Ctrl + C) and Paste (Ctrl + V) next to the box.

Add the second Revenue Item. Leave the last value blank

### Easy Excel Automation

In the Variance Column, select Second Value – First Value

In the + Column, enter formula =IF(H8>0,-H8,””) This will show all the positive values

In the = Column, enter formula =IF(H8<0,H8,””) This will show all the negative values

### Add the Variance % Column

For the Variance Column, divide the Variance % by the Revenue, H8/F8

### Creating the Graph

Create a Graph where the Year is your X Axis and the Revenue and Invisible Column are your Y Axis.

1. Uncheck the boxes for Gridlines and legend

2. Click on the Invisible Series

3. Click on the + Sign in the top right of the graph

4. Select the Arrow next to Error Bars

5. Select More Options

6. Under Format Error Bars, Select the Graph

7. For Direction, make sure Both is selected

8. For End Style, make sure Cap is selected

9. Under Error Amount, select Custom

10. Click on Specify Value

11. Highlight the Positive Values in Positive Error Value

12. Highlight the Negative Values in Negative Error Value

### Formatting the Graph

1. Right click on the Revenue Series
2. Click on Format Data Series

3. Change Series Overlap to 0%

4. Change Gap Width to 0%

Your graph should look something like this so far

5. Select Invisible Bars

6. Click Format

7. Select Shape Fill

8. Click No Fill

1. While still clicking the invisible bar, select the + Sign in the top right
2. Select arrow next to Data Labels
3. Select More Options

4. Select Graph under Format Data Labels

5. Check Value from Cells

6. Uncheck Value

7. Select Outside End

### Final Graph

The final graph shows the variance between each series.