sffere.blogg.se

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 that provides the detailed guidance for beginners.