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

    stacked bar chart grouping (Excel 2003)

    How can I create a stacked bar chart such that I have 5 groups of 3 (5 years, 3 sets of data for each year)? It'd look like this pix:

    I can fake it with making multiple charts and somehow overlaying them manually [img]/forums/images/smilies/smile.gif[/img]

    Thnx,
    Deb

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

    Re: stacked bar chart grouping (Excel 2003)

    Check out Creating a Clustered-Stacked Column Chart and the links provided there.

  3. #3
    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: stacked bar chart grouping (Excel 2003)

    Great stuff! So the secret is in how the data is organized and blank rows, very interesting. I'll definitely be using this more often as I have a lot of stacked charts and sometimes they're very hard to read.

    Thnx,
    Deb <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

Posting Permissions

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