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
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.
