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

Pingback: Basic Histogram Graphs | Passy's World of Mathematics

Pingback: Grouped Data Histograms | Passy's World of Mathematics

Pingback: Averages – Mean Median Mode | Passy's World of Mathematics

Pingback: Online Graph Makers | Passy's World of Mathematics

Pingback: Misleading Graphs | Passy's World of Mathematics

Pingback: Stem and Leaf Plots | Passy's World of Mathematics

Pingback: Real World Charts and Graphs | Passy's World of Mathematics

Pingback: Online Graph Makers | Passy's World of Mathematics

Pingback: Column and Pie Graphs in Excel 2007 | Passy's World – Old Site

Pingback: Grouped Data Histograms | Passy's World of Mathematics

Pingback: Basic Histogram Graphs | Passy's World of Mathematics

Pingback: Mean Median Mode for Grouped Data | Passy's World of Mathematics

Pingback: Stem and Leaf Plots | Passy's World of Mathematics

Pingback: Back to Back Stem and Leaf Plots | Passy's World of Mathematics

Pingback: Real World Line Graphs | Passy's World of Mathematics