chart with data source from multiple worksheets

  • Thread starter ×בי×ל
  • 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.
 
B

Bernard Liengme

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top