Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add Historical Data to Chart (Excel 2003)

    My chart shows data from the current year, but I would like to imprint the historical data from last year as well. Can anyone think of a way to dynamically show the values for 2006 on top of or next to 2007's points? Maybe I just need to restructure the worksheet's layout??
    Attached Files Attached Files

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

    Re: Add Historical Data to Chart (Excel 2003)

    See if the attached does what you want. I used the offset function to duplicate last year's data to the right of this year's data, and added new series. You have to fiddle a lot to get it right - Excel messes up the chart types and assignment to the primary/secondary axis.
    Attached Files Attached Files

  3. #3
    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: Add Historical Data to Chart (Excel 2003)

    Like this perhaps?

    Steve
    Attached Files Attached Files

Posting Permissions

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