×
×בי×ל
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.
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.