Excel -stacked- chart + % axe with the same data

[Jeff_The]

have created a chart to visualise the monthly variances of costs for a set of 10 tasks. It is a stacked bar with 'money'-values. the $-values are represented at the left hand axe. (In fact I copy -paste at the end of each month the values to the next 'month", and start again -on the most left position, with the 'actual' values.)
Now, I would like to have the same stacked bar, but with % (each of the 10 tasks).
This would be shown on the right hand axe (%- axe)
unfortunately, i cannot copy-paste a 'figure' to show (a picture tells more than a thousands words)
all assistance is very welcome

 

[Luke M]

Hi Jeff,

I wasn't sure if you wanted the percentages attached to the legend, or just free-floating on the right, so I did both. For the legend, I just manipulated the series names with a formula.

For the free floating on right, I created a Fake series on the secondary axis. Secondary axis are set to display no marks/labels. Then the Fake Series is linked to the percentages. Is this what you're wanting?

 

[Jeff_The]

Hello Luke M, indeed, this is pritty what I am looking for!! (I have made the % 'calculation' dynamic again, so the rh-axe value follows according the fluctuations of the $-values)

indeed, you are a Excel Ninja ! ;-) you passed for your title enjoy the day!

regards
Jeff