Excel 2007 Pie and Column Graphs

In this post we are going to look at how to make Column Graphs, and Pie Charts, using Microsoft Excel 2007.

Here is a five minute Jing video that shows how to make a basic column graph.

As soon as the video starts playing, click the very bottom right hand corner "full screen" icon.

This should make the movie full screen so that it can be viewed clearly.
You might have to also turn up your speakers to hear the audio narration.
To return back to this Blog, press the Escape key.



Here is a link to watch the above 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 previous Jing video 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).

As soon as the video starts playing, click the very bottom right hand corner "full screen" icon.

This should make the movie full screen so that it can be viewed clearly.
You might have to also turn up your speakers to hear the audio narration.
To return back to this Blog, press the Escape key.


Here is a separate link to go view the above Jing 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/

SOME FURTHER INFORMATION WE WOULD LIKE FROM OUR READERS IS THE REASON WHY THEY VISIT OUR SITE.

PLEASE DO OUR ONE CLICK SURVEY AT THE TOP RIGHT HAND CORNER OF THIS WEB PAGE. JUST CLICK ONE OPTION IN, AND THEN CLICK THE "VOTE" BUTTON.

Enjoy,
Big Passy Wasabi