line graph - show % change above line

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
2,046
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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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,221,525
Messages
6,160,329
Members
451,637
Latest member
hvp2262

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