Results 1 to 7 of 7
  1. #1
    bonnb
    Guest

    stacked bar charts (97 SR-2)

    I would like to create a hybrid chart where stacked bars are next to each other. The x-axis is months.
    For each month I would like to chart three stacked bars, where each stack includes 2 parts (stacked on
    each other). There are 6 series, 2 for each set of stacked bars. For each month, I can get excel to plot
    6 bars or 6 stacked sections in 1 bar, but how do I get it to plot 3 bars of 2 sections each?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: stacked bar charts (97 SR-2)

    Bernie

    Its hard to visualize what you are asking for, but if you would vary the rows where the data is, Excel will chart zero for that segment and then it looks like you have made it as if they are next to each other.

    Experiment by first visualizing the chart, then when you want the data to be on the side, move it one row under and one column over.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: stacked bar charts (97 SR-2)

    Bernie, it's really tough getting those bars next to one another: you have to do some creative data entry. Attached is a sample chart using Wassim's suggestions that is hopefully like what you want. The chart looks OK, but the data entry worksheet is rough. Maybe you could move some of the data around, but it would make the series formula really nasty, and you couldn't drag-and-drop a new month onto the chart. Hope this helps. --Sam
    Attached Files Attached Files
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    bonnb
    Guest

    Re: stacked bar charts (97 SR-2)

    Thanks to those who responded. I have been able to get excel to produce the graph I had in mind.
    The solution I used was anything but elegant, but it worked.

  5. #5
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: stacked bar charts (97 SR-2)

    Can you put in some fake data and show us? Just use the attach-a-file box just before you post it (note, attachment is lost when you preview, so wait until just before posting). Thanks! --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

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

    Re: stacked bar charts (97 SR-2)

    Hi folks,

    Too late for a solution, but not too late for the example SammyB's asking for: see the post #47726 dated 21-Jun-01 12:56 and thread Re: clustered stacked chart (sorry, I don't know how to put a link or shortcut into this message).

    See my attached file at the end, with an example of exactly what you were trying to create, Bernie. It is also a bit convoluted to create, you have to plot a calculated sum of stack 1 and stack 2 and set it on the primary axis as stack2, and set the series for stack1 on the secondary axis. Let me know if you would like the file again.

    Aloha,

    JohnJ

  7. #7
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: stacked bar charts (97 SR-2)

    Very nice example, John. Here is the entire <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=47726&page=&view= &sb=&o=&vc=1>thread</A>. (to create links, try the Click Tag Panel, experiment down in the Test Area board) Using the secondary axis was a great idea. <img src=/S/salute.gif border=0 alt=salute width=15 height=20> --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

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