How to show percentage inside bars in a stacked bar chart without changing Y axis style

**Actuary07** · 09-04-2017, 10:35 AM

Dear friends,

Hope you are all doing great. So I have the following information:

I have 2 vessel types: A and B.
I have two fiscal years FY 2016 and FY 2017.
I have the number of transits for vessel type A for both fiscal years (2016 and 2017)
And calculated what percentage of the total transits corresponds to vessel type A and vessel type B for both fiscal years.

I would like to create a stacked bar chart containing the values 2016 and 2017 for the x-axis, and then different colors in the bars for the two vessel types. In addition to that, I would like to show only the percentage of total transits inside the bars while keeping the y-axis in a number style and not as a percentage.

How can I accomplish this? If you guys need the sample data let me know how I can make it available to you guys from here. Also, when a value is very small compared to others, the bar representing it is almost impossible to view, how can I adjust this so that I can fit the label inside that bar?

Thanks, beforehand for your valuable help,

Best regards,

Paul

**MrShorty** · 09-04-2017, 10:43 AM

Your profile says 2010, so I would:

1) Compute the desired percentage somewhere adjacent to the values in the spreadsheet.
2) Use Rob Bovey's free XY chart labeler add-in (appspro.com ) to add these cells as data labels to the stacked bar series.

If, perchance, your profile has not been updated and you really have 2013 or later, then I would do the same thing, just use the built in "value from cells" feature in the format data labels dialog.