% in Graph ?!? Impossible?

Nevarone

New Member
Joined
Apr 7, 2015
Messages
1
Hi guys!

I have a really difficult problem I wish could be solved but I am loosing my hope on this one, thus I turn to you experts. The chart below is a pivot chart from a pivot table. It displays 4 categories and is mapped out as they should be, according to their values.

This is what it should look like BUT, and it is a BIG but, I also want, at the same time as howing the values as it does also show ON/ABOVE/UNDER each category's plotted line the percentage it has changed since last "marker / dot / plot" in this case, last quarter. Please see example on image 2 below.

I also want to make one graph that looks like I have it but instead of showing percentage of the previous "quarter" use my first quarter as index and instead show the % of change from the index year. See image 3 below for an exmaple.

Does anyone know if this is possible or if there is any work arounds or if there are any Add-ins / plugg-ins etc that can solve this problem to show what I want to show!?!

Super appreciate help in this matter! :)


14niivk.png






30us84i.png




2iuavd5.png
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Does it need to be a pivot graph? This is simple to do on a normal graph, using data labels.
 
Upvote 0
not used pivot charts much, can you model on a secondary axis, creating the change data in your original table to use as labels
 
Upvote 0

Forum statistics

Threads
1,224,126
Messages
6,176,521
Members
452,733
Latest member
Gao87

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