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! If you would like to submit an idea for an article, or be a guest writer on our blog, then please email us at the hotmail address shown in the right hand side bar of this page.A while ago we published the first part of our Excel charts tutorial that provides the detailed guidance for beginners. To find out exactly how free subscription works, click the following link:

Go to the subscribe area on the right hand sidebar, fill in your email address and then click the “Subscribe” button. You can then receive notifications of new pages directly to your email address. If you enjoyed this post, why not get a free subscription to our website. Grouped Data Histograms Using Class IntervalsĪverages – Mean Median Mode (including MS Excel) There are some good free tutorials, as well as very useful add-ons that can be purchased for Excel 2007 at this website: See the “How to Pie Chart” video full size at Screencast (The screen will go white for a few sections while the video loads in from the Jing screencast site).Ĭlick the following link to go and view our five minute Pie Graphs video full size on the “screencast” website: It is all about how to make a Pie Chart in Microsoft Excel 2007. Here is a five minute Jing video that we made here at Passy World. The Screencast Jing video in the link above, included a demonstration on how to do this axis labels staggering.

It then makes everything look and fit better: 24cm, 26cm, 28cm etc and this staggers the horizontal axis labels. We can make an Alt-Enter carriage return in front of every second measure, eg. When we added the cm units onto our Foot Lengths, the Horizontal axis became very cluttered with them jammed up against each other like this: In this post we are going to look at how to make Column Graphs, and Pie Charts, using Microsoft Excel 2007.Ĭlick the following link to watch our five minute Column Graphs video at :

Make a pie chart in excel 2007