chart with data source from multiple worksheets
 

I want to define the data soutce of a chart from multiple different
worksheets in a way that all the data will be in the same series because I'm
using trend line.
I've tried just refering like: ='81001'!$E$2:$F$71+'81002'!$E$2:$F$93
but received an error.

chart with data source from multiple worksheets
 

On one sheet, gather your data with formulas like
='81001'!E2

Then chart the resulting data
best wishes

--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"אביאל" wrote in message
...
I want to define the data soutce of a chart from multiple different
worksheets in a way that all the data will be in the same series because
I'm
using trend line.
I've tried just refering like: ='81001'!$E$2:$F$71+'81002'!$E$2:$F$93
but received an error.

chart with data source from multiple worksheets
 

I have alot of information from alot of worksheets and this way is a little
bit long.
Is there a simple way of doing that?

"Bernard Liengme" wrote:

On one sheet, gather your data with formulas like
='81001'!E2

Then chart the resulting data
best wishes

--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"אביאל" wrote in message
...
I want to define the data soutce of a chart from multiple different
worksheets in a way that all the data will be in the same series because
I'm
using trend line.
I've tried just refering like: ='81001'!$E$2:$F$71+'81002'!$E$2:$F$93
but received an error.