Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charting: Multiple workbooks one chart
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. "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting: Multiple workbooks one chart | Excel Discussion (Misc queries) | |||
Charting: Multiple workbooks one chart | Excel Discussion (Misc queries) | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
Chart not charting right | Charts and Charting in Excel | |||
CHARTING AND EDITING CHART | Excel Discussion (Misc queries) |