Charting: Multiple workbooks one chart
 

Sure.

Make the chart with Workbook A's data. Go to Workbook B, select the
column F data, hold CTRL while you select the column I data, so both
areas are highlighted, copy using CTRL+C. Select the chart in Workbook
A, use Paste Special to add the data as a new series.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



engineer3518 wrote:
I have workbook A and workbook B.

I want to create a chart in workbook A that plots column I data (y-axis)
verse column F (x-axis).

I then want to pull workbook B's column I data in to be plotted as an
additional series with reference to its workbook B column F data.

My question: Is is possible to have both workbook A and workbook B data
series plotted on one chart with reference to their own column F values?

Right now when I attempt this any additonal series is only plotted in
reference to the row number. I need each series plotted on the same chart in
reference to its corresponding column F data.

Any suggestions would be appreciated, Thanks.