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

Here are some guidelines:

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

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


"Earl" wrote in message
...
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

Is this at the Data Range or Series? Thanks

"Joel" wrote:

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.

"Earl" wrote:

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

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.

"Earl" wrote:

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

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
_______


"Joel" wrote in message
...
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.

"Earl" wrote:

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