View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
אביאל אביאל is offline
external usenet poster
 
Posts: 2
Default 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.