Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Paul B.
 
Posts: n/a
Default 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

  #2   Report Post  
bj
 
Posts: n/a
Default

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

  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
tick mark labels Debrane Charts and Charting in Excel 9 July 19th 05 02:53 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Line chart in Excel - trendline incomplete [email protected] Charts and Charting in Excel 7 May 13th 05 01:21 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 09:48 PM


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"