Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is there any way to add labels to each bar in the stacks for the attached chart so as to show the percentage number?
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I think you would have to actually calculate the percentages in the base data and then plot those instead.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [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.
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    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. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [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.
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [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. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [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.
    Attached Images Attached Images

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    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
  •