In this post we are going to look at how to make Column Graphs, and Pie Charts, using Microsoft Excel 2007.
Click the following link to watch our five minute Column Graphs video at Screencast.com :
http://www.screencast.com/t/YjI0MDk0
Creating an Uncluttered Horizontal Axis
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:
We can make an Alt-Enter carriage return in front of every second measure, eg. 24cm, 26cm , 28cm etc and this staggers the horizontal axis labels.
It then makes everything look and fit better:
The Screencast Jing video in the link above, included a demonstration on how to do this axis labels staggering.
Making Pie Charts in Excel 2007
Here is a five minute Jing video that we made here at Passy World. It is all about how to make a Pie Chart in Microsoft Excel 2007.
(The screen will go white for a few sections while the video loads in from the Jing screencast site).
Click the following link to go and view our five minute Pie Graphs video full size on the “screencast” website:
See the “How to Pie Chart” video full size at Screencast
Further Information
There are some good free tutorials, as well as very useful add-ons that can be purchased for Excel 2007 at this website:
http://peltiertech.com/Excel/Charts/
Related Items
Basic Histogram Graphs
Grouped Data Histograms Using Class Intervals
MS Excel Charts and Graphs
Funny Graphs from Graph Jam
Real World Line Graphs
Averages – Mean Median Mode (including MS Excel)
Free Online Graph Makers
Misleading Graphs
Stem and Leaf Plots (Stem Plots)
Real World Charts and Graphs
If you enjoyed this post, why not get a free subscription to our website.
You can then receive notifications of new pages directly to your email address.
Go to the subscribe area on the right hand sidebar, fill in your email address and then click the “Subscribe” button.
To find out exactly how free subscription works, click the following link:
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.
Enjoy,
Passy