Charting: Multiple workbooks one chart

[engineer3518]

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.

 

[Jon Peltier]

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

 

[Luke M]

Create a XY scatter chart using the data from workbook A. Then, using Ctrl to
select discontinuous ranges, highlight the F and I data from workbook B. Copy.

Select your chart, then go to Edit - Paste special. Paste a new series,
values in columns, and check the boxes for "series name in first row" and
"categories in first column".

You should now have both series on your chart, each using their own set of F
data.

 

[Brendan]

Yes it is possible using the xy (Scatter) plot Type. My guess is that you're
currently using a line or bar type. These types plot everything evenly spaced
- the xy plot allows you to plot vs. another data set.