Combine varied data from separate workbooks into one chart

[Earl]

I want to combine varied data from separate workbooks into one chart.

Data is collected at varied date intervals and level ranges (11/03-2/07) &
(0-100). Data begins with 24k rows and is filtered to 1K.

Individual charts display daily data labeled as varied mm/dd/yy on the
‘Category Axis’ and 0-40, 0-60 & 0-100 on the ‘Value Axis’. Adding additional
‘Series’ just gives one horizontal line.

TIA

 

[Jon Peltier]

Here are some guidelines:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

- Jon

 

[Earl]

Is this at the Data Range or Series? Thanks

When referencing cells from different workbook use the following:

[abc.xls]sheet1!A1


Open the two wookbooks at the same time and make the chart the same way you
normally would witth one workbook. If you highlight the cells you want to
put into the chart, excel will autmatically add the proper reference between
workbooks.

I want to combine varied data from separate workbooks into one chart.

Data is collected at varied date intervals and level ranges (11/03-2/07) &
(0-100). Data begins with 24k rows and is filtered to 1K.

Individual charts display daily data labeled as varied mm/dd/yy on the
‘Category Axis’ and 0-40, 0-60 & 0-100 on the ‘Value Axis’. Adding additional
‘Series’ just gives one horizontal line.

TIA

 

[Joel]

When referencing cells from different workbook use the following:

[abc.xls]sheet1!A1


Open the two wookbooks at the same time and make the chart the same way you
normally would witth one workbook. If you highlight the cells you want to
put into the chart, excel will autmatically add the proper reference between
workbooks.

 

[Jon Peltier]

Note that you'll need to enclose the workbook/worksheet reference in single
quotes if the names contain spaces.

Another way to add data to a chart and let Excel build the references is to
copy the data, select the chart, and use Paste Special.

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

When referencing cells from different workbook use the following:

[abc.xls]sheet1!A1


Open the two wookbooks at the same time and make the chart the same way
you
normally would witth one workbook. If you highlight the cells you want to
put into the chart, excel will autmatically add the proper reference
between
workbooks.

I want to combine varied data from separate workbooks into one chart.

Data is collected at varied date intervals and level ranges (11/03-2/07)
&
(0-100). Data begins with 24k rows and is filtered to 1K.

Individual charts display daily data labeled as varied mm/dd/yy on the
'Category Axis' and 0-40, 0-60 & 0-100 on the 'Value Axis'. Adding
additional
'Series' just gives one horizontal line.

TIA