line graph - show % change above line

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
2,056
Office Version
  1. 365
Platform
  1. Windows
I am graphing some government Producer Price Indices, based on the index published for Dec each year, relevant to our products to get an idea of price movement over time. Using a line graph with markers, is there any way to get the % change in yearly index value as a line label between the markers? so, if Dec 20 was 100, Dec 21 was 107, Dec 22 was 111, the line from Dec 20 to Dec 21 would be labelled 7%, from Dec 21 to Dec 22 would be 3.7% and so on.

is it possible?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
HI
I think it could be enough to create a series with the differences (in percentage) between one data point and another and then indicate these as labels.

HI,
Mario
 
Upvote 0
HI
I think it could be enough to create a series with the differences (in percentage) between one data point and another and then indicate these as labels.

HI,
Mario
Thanks Mario. not sure how that would work given the percentage changes are not linear
 
Upvote 0

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top