Quantcast

Excel question. making a chart with data from multiple worksheets

Discussion in 'The Lounge' started by pnj, Aug 10, 2012.

  1. pnj

    pnj Turbo Monkey till the fat lady sings

    Rep/Likes:
    12 / 40
    Joined:
    Aug 14, 2002
    Messages:
    4,720
    Location:
    seattle
    I have three sheets with two columns each.

    I want a chart that compares the data from these sheets.

    the only way I can get it to work is by combining all the data from the three sheets onto a new sheet. That is fine but what happens when I get lots and lots of worksheets?

    Is there a better way to do this?
     

    Please register to disable this ad.

  2. ALEXIS_DH

    ALEXIS_DH Tirelessly Awesome

    Rep/Likes:
    19 / 108
    Joined:
    Jan 30, 2003
    Messages:
    5,286
    Location:
    Lima, Peru, Peru
    ='(sheet1)'!K1(or whatever cell from sheet1 you want to take)
     
  3. ridiculous

    ridiculous Turbo Monkey

    Rep/Likes:
    5 / 1
    Joined:
    Jan 18, 2005
    Messages:
    2,917
    Location:
    MD / NoVA
    Where are you getting your data from? If you are importing, just keep it all on one sheet.

    Also, when you are selecting data you can grab data from whatever sheet you want to make a new series. Or at least you can in excel 2010.
     
  4. dante

    dante Unabomber

    Rep/Likes:
    11 / 8
    Joined:
    Feb 13, 2004
    Messages:
    8,998
    Location:
    looking for classic NE singletrack
    This, although when you are defining the data set for your graph, just click on whatever page you want and highlight the cells. You can even link it to other files, but then things start getting complicated (and it'll prompt for updating it when you open the graph).