Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    combine two stacked charts (Excel 2003)

    I have two stacked charts each showing two data sets. I'd like to combine them into one chart but I still want two vertical bars with two data sets each (not one vertical stacked bar with four data points). I can't see how to combine these w/o resulting in a single bar graph. Is there a trick or is this not possible?

    Data1 80,120
    Data2 170,250

    So I had two charts with one stacked bar each but can I have two stacked bars with two data points on one chart?

    Thnx,
    Deb

  2. #2
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combine two stacked charts (Excel 2003)

    Great! Thanks for the link, very useful stuff.

    Deb

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: combine two stacked charts (Excel 2003)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    Yes it is possible.

    Try this site : http://peltiertech.com/Excel/Charts/format.html#tornado

    scroll down to where it says clustered stacked column shart and click on the heading for instructions.
    It has 4 links, one of which has a sample.

    I've found it very helpful.

    Microsoft also has an article titled : How to create charts with multiple groups of stacked bars


    capri

Posting Permissions

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