Combine varied data from separate workbooks into one chart

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

Guest

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 said:
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 said:
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
Click to expand...
Click to expand...
 
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.
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top