Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Help with two series stacked column chart (2003)

    Hi,

    I need help with this chart. Ideally I need to compare 2006 with 2007 data in a stacked column. Any assistance on the sample attachment will be appreciated.

    TX
    Attached Files Attached Files
    Regards,
    Rudi

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Help with two series stacked column chart (2003)

    How about this?

    Instead of 2 sets of 2 stacks, it creates columns with 4 series. Every other series has the 2 alternating sets.

    Steve
    Attached Files Attached Files

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Hamilton, Waikato, New Zealand
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with two series stacked column chart (2003)

    As an alternative, you could just have two charts - one for each year - of the same size and scale etc. The second chart has plot area fill, chart area fill, axis and gridlines removed and is over laid on the first giving the appearance of one chart as attached.

    cheers
    Andrew
    Attached Files Attached Files

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Help with two series stacked column chart (2003)

    Thanks a stack Steve and Drakon.

    That helps!
    Cheers
    Regards,
    Rudi

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Help with two series stacked column chart (2003)

    You are welcome.

    In case it is not obvious, you can separate the spacing between categories with additional blank rows in the data if desired. To get the category label to be exactly in the middle of the 2 requires an additional "trick" (using a second X-axis and datalabels) but your "sample" showed it near the first one so it did not require it.

    Steve

Posting Permissions

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