Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Stacked bar with totals (Excel 2002)

    We would like to create a stacked bar chart with the values on the bars and the total of each stack displayed at the top of the stacked bar. Our work-around was to just type the totals in text boxes. The chart will grow with each month's data being added to the worksheet. We would like to have the totals display automatically.

    We thought we could use a combined chart, but we couldn't get a stacked bar chart with a line. We figured we could turn the line itself off and just display the values. We must be missing something.

    I know that this group will have the answer.

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stacked bar with totals (Excel 2002)

    You could add a dummy series, make it transparent, and add the totals as data labels for this series using Rob Bovey's free XY Chart Labeler.
    These data labels will not be updated automatically, but the Chart Labeler makes it very easy to add them again.
    See attached workbook.

  3. #3
    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

    Re: Stacked bar with totals (Excel 2002)

    You could also plot the series on the secondary axis and add data labels to it. If the series is just the total of the other three, then the scale should be the same on both axes, I think?
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stacked bar with totals (Excel 2002)

    Yes, that was my first thought too. But the only options for data labels are centered, inside bottom and inside top, there is no option for 'just above the column'.
    If the OP can live with labels near the top of the stacked columns, it would be an automated solution.

  5. #5
    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

    Re: Stacked bar with totals (Excel 2002)

    If you use a stacked bar type for that series too, then you have Outside End as an option? See attached.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stacked bar with totals (Excel 2002)

    Excellent! That's the best solution, then!

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

    Re: Stacked bar with totals (Excel 2002)

    Small correction to what I said - the fourth series is not actually a stacked bar type, just a bar type.
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Stacked bar with totals (Excel 2002)

    Thanks, Rory and Hans.

    I now have a few ideas. I'll let my user decide the easiest for her.

Posting Permissions

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