Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting a line and a bar on the same chart | Charts and Charting in Excel | |||
Pie Chart Not Charting Properly | Charts and Charting in Excel | |||
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) |