Creating two charts in one
I have two spreadsheets, I would like to create one chart from both
spreadsheets. Is it possible to create a chart like this, how do you tell it what range? Thanks in advance for your assistance. |
Steve -
Make the chart with data from one worksheet. Then add data from the other worksheet (can be in a different workbook). There are several ways. One is to copy the data, switch to the chart, and use Paste Special to paste the data into the chart as a new series. Another way is to use the Source Data command on the Chart menu, select the Series tab, click Add, and when you click on the input boxes for worksheet ranges for the series data, you are able to select other sheets by clicking the tabs at the bottom, and other workbooks by using the Window menu. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ stevel wrote: I have two spreadsheets, I would like to create one chart from both spreadsheets. Is it possible to create a chart like this, how do you tell it what range? Thanks in advance for your assistance. |
All times are GMT +1. The time now is 05:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com