how to plot a graph in excel with a range of points

Click the Expand Dialog to return to the initial Edit Series window. On the second worksheet, select a column or a row of data you want to add to your Excel graph, and then click the Expand Dialog icon to get back to the full-sized Edit Series window.Īnd now, click the Collapse Dialog button to the right of the Series name field and select a cell containing the text you want to use for the series name. Click on the tab of the sheet that contains the other data you want to include in your Excel chart (the Edit Series window will remain on-screen as you navigate between sheets). The Edit Series dialog will shrink to a narrow range selection window. This is the key point, so please be sure to follow the instructions closely.Ĭlicking the Add button opens the Edit Series dialog window where you click the Collapse Dialog button next to the Series values field. Now we are going to add the second data series based on the data located on a different worksheet. In the Select Data Source window, click the Add button. Or, click the Chart Filters button on the right of the graph, and then click the Select Data… link at the bottom.

Add a second data series from another sheetĬlick on the chart you've just created to activate the Chart Tools tabs on the Excel ribbon, go to the Design tab ( Chart Design in Excel 365), and click the Select Data button. In this example, we will be creating the Stack Column chart:Ģ. Open your first Excel worksheet, select the data you want to plot in the chart, go to the Insert tab > Charts group, and choose the chart type you want to make. Supposing you have a few worksheets with revenue data for different years and you want to make a chart based on those data to visualize the general trend. How to create a chart from multiple sheets in Excel

Customize a chart created from several sheets.

Make a chart from multiple Excel sheets.

Fortunately, Microsoft Excel provides a way to plot data from two or more different worksheets in a single graph. Indeed, when creating charts in Excel, the source data does not always reside on the same sheet. And the very first question posted in comments was this: 'And how do I created a chart from multiple tabs?' Thanks for this great question, Spencer! A while ago we published the first part of our Excel charts tutorial for beginners that provides the detailed guidance on how to make a graph in Excel.

How to plot a graph in excel with a range of points