Quantcast

Excel question. making a chart with data from multiple worksheets

pnj

Turbo Monkey till the fat lady sings
Aug 14, 2002
4,696
40
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?
 

ridiculous

Turbo Monkey
Jan 18, 2005
2,907
1
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.