chart with data source from multiple worksheets

  • Thread starter Thread starter ×בי×ל
  • Start date Start date
×

×בי×ל

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.
 
On one sheet, gather your data with formulas like
='81001'!E2

Then chart the resulting data
best wishes
 
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?
 
Back
Top