Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts

    clustered stacked chart

    Excel 97 SR-2: is it possible to have a clustered stacked column chart - i.e. if I want to show 2 stacked columns for each of my x-axis categories, and I want them clustered (i.e. adjacent) for visual effect?

    Thanks

    Jeremy

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: clustered stacked chart

    Jeremy,

    I'm not sure if I understand your exact requirements, but would a standard stacked bar graph suffice. For the 'cluster' effect go to Format Data Series, select the Options Tab and set the Gap Widthh to zero.

    Hope that gives you what you want

    Andrew C

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: clustered stacked chart

    I asked this question in the old Lounge a long time ago and no one came up with a solution, but if there is one I would like to see it. I finished up getting a colleague to do the job in S+.

  4. #4
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts

    Re: clustered stacked chart

    I've now managed to locate something that appears to do what I want on Stephen Bullen's BMS website.

    Jeremy

  5. #5
    New Lounger
    Join Date
    Apr 2001
    Location
    Honolulu, HI
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: clustered stacked chart

    So Andrew has it corrrect then? Sounds like it by your original question.

    You can contrive the appearance a multiple-cluster stacked chart, but it's a bit convoluted. Example is attached. The first stack is plotted on the secondary y-axis. The second stack is actually the sum of the two stacks that would be plotted in a typical stacked chart, and is plotted on the primary axis to get it to appear behind the first stack. This way it appears stacked, but it's really just two co-located sets of series on different axes.

    You may have to set each y-axis to the same maximum scale. The chart could also be cleaned up a little. Legend items can be manually re-ordered or deleted, and the secondary y-axis can be deleted or formatted to be invisible (white font and line color).

    This method works with only two stacks.

    John Jacobson
    Attached Files Attached Files

Posting Permissions

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