How to Chart Cells From Two Different Worksheets in Microsoft Excel

Create the Chart
1. Enter data in rows by using row headers with data under them. You can also choose to enter data in columns by using column headers with data under them.
2. Select the cells containing the data you will use for the chart.
3. Select the 'Insert' tab on the top menu, and click the arrow in the bottom-right corner of the Charts group to open the Insert Chart window.
4. Choose the type of chart in the Templates column of the Insert Chart window.
5. Select the chart using the images in the right box in the Insert Chart window, and click the 'OK' button.
6. Move your embedded chart by clicking anywhere in the chart to activate the Chart Tools option on the top menu.
7. Click 'Chart Tools' on the top menu, select the 'Design' tab, and click the 'Move Chart' button in the Location section of the menu.
8. Embed the chart in any sheet in the workbook using the pull-down menu in the Object In option in the Move Chart window, if you choose to. Click the 'OK' button when you are done.
9. Move the chart to a new sheet that you can name using the box next to the New Sheet option in the Move Chart window, if you want to. Click the 'OK' button when you are done.
Add Data from a Second Worksheet to the Chart
10. Click anywhere in the chart to activate it.
11. Click 'Chart Tools' on the top menu, and select the 'Design' tab.
12. Click the 'Select Data' button in the Data section of the Design tab to open the Select Data Source window.
13. Click the 'Add' button in the Legend Entries (Series) box of the Select Data Source window to open the Edit Series window.
14. Name the series in the Series Name box. You can choose to type in a name or link to a cell that contains the name.
15. Select the square box next to the Series Name box in the Edit Series window to link to the name of the series. If it is on another worksheet, click the tab of that worksheet, select the cell containing the name, and click the square box in the Edit Series window.
16. Select the square box next to the Series Values box in the Edit Series window to select the data range you want to include in your chart.
17. Click the tab for the sheet containing the data, and select the range of data you want to include on your chart, and then click the square in the Edit Series window. Click the 'OK' button to include the new data from a second worksheet in your chart.