• 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.

Is there any way to show the percentage value in a 100% Stacked Column chart?

justinparker

New Member
I'm currently displaying percentages in a Stacked Column chart. After realizing that rounding errors could throw off my displayed percentages, I decided to use the 100% Stacked Column chart. The limitation that I have in this switch is that I'm unable to display the percentage values in my chart. Any suggestions in how I can leverage the 100% Stacked Value chart AND still be able to display the percentage value?


Thanks!
 

Hui

Excel Ninja
Staff member
Instead of charting the data directly I would setup some helper cells where you do the conversions to 100% yourself

Then chart of the helper cells

Once charted you can select each series and set the Data Labels to display the value
 

keymaster

New Member
Also, you can try Rob's free chart labeler addin to change the chart lables in umpteen ways. It might be helpful if you are doing this an awful lot of time.


http://www.appspro.com/Utilities/ChartLabeler.htm
 
Top