+ Reply to Thread
Results 1 to 3 of 3

How to create a stacked, staggered column graph w/ 2 y axes

  1. #1
    Registered User
    Join Date
    11-14-2007
    Posts
    9

    How to create a stacked, staggered column graph w/ 2 y axes

    Hi everyone. I searched the forum and couldn't find any answers to this. I'm trying to compare two years worth of data using the following information:

    Stacked: A vs B
    Staggered: 2006 vs 2007
    2 Axes: % of A to B 2006 vs % of A to B 2007


    Anybody have a clue on how to do this? I can create a stacked graph of 2006-2007 data w/ a y axes for % of A to B; but it would make much more sense if i could compare the years to look for seasonal trends. any ideas?

  2. #2
    Registered User
    Join Date
    08-27-2003
    Location
    Perth, Australia
    MS-Off Ver
    2000
    Posts
    47
    Hi
    I'm not quite clear what you want to stack, but it is possible to have side-by-side columns. Is this what you're after?
    Attached Files Attached Files
    Nicky

  3. #3
    Registered User
    Join Date
    11-14-2007
    Posts
    9
    Nicky,
    Pretty close. I was looking to stagger the 06 against the 07 data and overlay two line y axes as well.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1