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