Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Minneapolis, MN
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart from multiple pages? (Excel 2000/SR-1)

    I've got a worksheet with 1 page for each month. Anyone know a way to graph a whole year's worth of data? I can't figure out how to get the Chart function to access more than one sheet of data at time. <img src=/S/frown.gif border=0 alt=frown width=15 height=15>

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Chart from multiple pages? (Excel 2000/SR-1)

    My understanding of Charts in Excel is that they can not chart data from multiple sheets.

    You can get around this by using one sheet to store the data for the chart and link the data in this sheet to the sheets storing the monthly data. (Try paste link or settiing the cells equal to eachother...)

    HTH
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Chart from multiple pages? (Excel 2000/SR-1)

    It really depends on what you're trying to achieve. You can have data from multiple sheets on the one chart, but they have to be treated as independent data sets and that limits what you can do. See the attached for a simple example.
    Attached Files Attached Files
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart from multiple pages? (Excel 2000/SR-1)

    It's not difficult, you just have to know the trick!

    Create your chart with the data of the first month.

    Go to the next sheet, select both x and y data, press copy, select the chart again, choose Edit, paste special. Make sure to check the boxes you see appropriate (like whether you have the categories included in the paste, whether it's rows or columns, etc.).

    Repeat for each month.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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