graph with data from several sheets

  • Thread starter Thread starter Sveta
  • Start date Start date
S

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!
 
Back
Top