Thread: Stacked Bar Chart Percentage Labels

1. Is there any way to add labels to each bar in the stacks for the attached chart so as to show the percentage number?

2. I think you would have to actually calculate the percentages in the base data and then plot those instead.

3. [quote name='rory' post='792406' date='07-Sep-2009 09:22']I think you would have to actually calculate the percentages in the base data and then plot those instead.[/quote]
Hi Rory :-), thanks. How do you dispense with the zeros in the chart? I've tried using zero-length strings in the cells' IF condition to no avail.

4. Change the formula in E2 to

=ROUND(B2/SUM(\$B2:\$D2)*100,0)

and similar for the other cells.

Apply the custom number format 0;; to E2:G21. This will hide 0 values.

5. [quote name='HansV' post='793838' date='18-Sep-2009 08:29']Change the formula in E2 to

=ROUND(B2/SUM(\$B2:\$D2)*100,0)

and similar for the other cells.

Apply the custom number format 0;; to E2:G21. This will hide 0 values.[/quote]
Thank you so much Hans :-)
I had to format the series data labels with 0;; as well otherwise the zeroes would still show on the chart.

6. [quote name='grovelli' post='793839' date='18-Sep-2009 09:48']I had to format the series data labels with 0;; as well otherwise the zeroes would still show on the chart.[/quote]
Alternatively, you can tick the check box "Linked to source" in the Number tab of the Format Data [s]Series[/s] Labels dialog - this will make the data labels use the same number format as the source data.

7. [quote name='HansV' post='793840' date='18-Sep-2009 08:51']Alternatively, you can tick the check box "Linked to source" in the Number tab of the Format Data Series dialog - this will make the data labels use the same number format as the source data.[/quote]
Is that a feature of Excel 2007? I don't see the number tab in the Format Data Series dialog.

8. Sorry, I meant the Format Data Labels dialog, of course.

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•