MS Excel - How to add percentage increase to the forecast chart and/or pivot table?

I've managed to successfully create a Forecast line chart. It has produced a table including forecast values, which is great. However, I'd really like to know what % increase it's working on? How would I go about adding this column to the Forecast table?

1 Answer

You need to follow these steps:

1. Using Source Data find Forecast in Col C.

1. Plot the Line Chart.

2. Find the difference in Cell Col D by using this Formula in cell D103, apply Percentage cell format.

   =IF(B103="","",(C108-B103)/B103).

3. Write click Plot Area & click Select Data.

4. This time add Range D103:D108 and name it to Difference.

5. Select the Difference Series and apply Cell Value as Data Label.

6. Finally add Secondary Axis to the Chart.

You find this:

Adjust Cell references as needed.