graph with data from several sheets

[Sveta]

I have a workbook with several worksheets. On every worksheet there is data.
I need to be able to create a chart, which has series of data from all
worksheets.
For me it should be something like this.
=SERIES(;;(sheet1!$E$6;shet2!$D$5;sheet3!$F$9);1)

But this Excel tells me, that there is an error in the expression. I can
only use this without errors, if there are data from one sheet. But I need
from more than one.
Please help!

 

[Jon Peltier]

Hi Sveta -

You can use formulas to collect data from several sheets onto one sheet used for the
chart data:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______