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
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.
0 kommentar(er)
