• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

Jeff_The

New Member
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
 

Attachments

  • Book1.xlsx
    46 KB · Views: 5
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?
upload_2016-1-14_9-7-17.png
 

Attachments

  • Book1 LM.xlsx
    16.9 KB · Views: 11
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
 
Back
Top