Line chart from multiple worksheets

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


"Paul B." wrote:

> 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
>

BJ's right, all data in either the X values or Y values of a chart
series must be on the same sheet, though X and Y can come from different
sheets or workbooks. This eb page has a little more information:

http://peltiertech.com/Excel/ChartsH...iffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


bj wrote:
> 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
>
>
> "Paul B." wrote:
>
>
>>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
>>