Line chart from multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all...

I am having some difficulty in creating a line chart from multiple worksheets.

All the data elements are in the same field on all worksheets, on worksheet
for each month.

I need to create a line chart using the data contained in several fields,
for example:

Chart one, line one, all data contained in the 12 worksheets located in
field B13
Chart one, line two, all data contained in the 12 worksheets located in
field D34

Any assistance would be greatly appreciated.

Cheers
 
I don't think you can do it conveniently
your best bet is to probaly use a helper sheet
in column A enter all of your sheet names
in column B enter
=indirect(A1&"!B13")
and copy down
in column C enter
=indirect(A1&"!D34")
and copy down

plot these columns
 
Back
Top