Thread: chart with data source from multiple worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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.

Reply With QuoteReply With Quote