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. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

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

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