Column and Pie Graphs in Excel 2007

Sorry Picture Not Found

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:

Sorry Picture Not Found

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:

Sorry Picture Not Found

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

Sorry Picture Not Found

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:

How Free Subscription Works

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

Share
Posted in Graphs, Statistics | Tagged , , , , , , | 15 Comments

Excel 2007 Charts and Graphs

Sorry Picture Not Found

This post is all about Making Charts and Graphs in Excel 2007.

Here at Passy World we have scoured the web and identified some great slide shows and Free Online Tutorials. These will soon turn you into an Excel Charts Wizard.

First of all there is plenty of good help for Excel at various Microsoft pages, such as the one shown below. This page has an excellent five and a half minute demo video on how to make charts and graphs from spreadsheet data.

Excel Charts “How To” video

Click the link below to open the Microsoft page which has the video:

http://office.microsoft.com/en-us/excel/ha102004991033.aspx

Here is a great beginners slideshow about Excel Charts from Slideshare.

 

(Note that we can click on the “Full” icon at the bottom to go full screen, and then simply press the Escape key to return to this Blog page).

[slideshare id=3074983&doc=finalinstructionsdraft-100204174319-phpapp01]
Here is a more detailed Slideshare on creating a basic comparison series Bar Graph in Excel:

[slideshare id=1204952&doc=excel2007-createachart-090326145127-phpapp01]
Here is a twenty seven slide presentation all about making Excel Graphs:

[slideshare id=1003250&doc=excel-2007-unit-d-1234079979919310-3]

Online Tutorials for Excel 2007 Charts

There is a very basic online tutorial about using Excel 2007 to make a basic bar graph here:

http://www.homeandlearn.co.uk/excel2007/excel2007s3p2.html

There is a more detailed online Tutorial about making Graphs at the following web page:

http://www.baycongroup.com/excel2007/04_excel.htm

So get into those Excel Graphs for your mathematics classes!

Finally, here is an Excel 2007 graph of some Online Survey results for the Passy’s World of ICT Site

Sorry Picture Not Found

Related Items

Basic Histogram Graphs
Grouped Data Histograms Using Class Intervals
MS Excel Column Graphs and Pie Charts
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:

How Free Subscription Works

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

Share
Posted in Graphs, Statistics | Tagged , , | 15 Comments

Integers Order of Operations

Bodmas Pemdas Rules In countries like Australia, we use the “BODMAS” or “BOMDAS” Rule for doing maths operations in the correct order.
In the USA, and some other countries, use the “PEMDAS” Rule for doing their maths operations. “Operations” are any of the following: Brackets, Squares, Powers, Square Roots, Division, Multiplication, Addition, and Subtraction. Operations Introduction Consider the following question: 1 + 2 x 5 There are two possible ways of doing this question: the right way, and the wrong way! Bodmas of 1 plus 2 times 5 If you are having trouble thinking about which one is the correct answer, then think about a money sum.
If someone gave you one dollar plus two five dollar notes, then the total would be $11.
It would not be $15. Now consider this next question: 2 + 3 x -4 Again there are two possible ways of doing this question: the right way, and the wrong way. Bodmas Integers wrong and right example We must follow the “Order of Operations” carefully in Mathematics to arrive at correct answers.   BODMAS Video For countries like Australia that use BODMAS, the following five minute video covers how everything works. [youtube http://www.youtube.com/watch?v=kISbq2p8ZOs]     PEMDAS Video For countries like the USA which use PEMDAS, the following ten minute Video explains all of the key concepts. [youtube http://www.youtube.com/watch?v=ClYdw4d4OmA]     Integers Examples   Example 1 : Multiplication and Addition Bodmas Example 1     Example 2: Multiplication and Division Bodmas Example 2     Example 3: Brackets Multiplication and Division Bodmas Example 3     Example 4: Brackets Division and Multiplication Bodmas Example 4       Example 5: Brackets Addition and Subtraction Bodmas Example 5     BODMAS / Pemdas Summary Once you have done a few practice questions, the following should become a lot more familiar. Bodmas Summary     BODMAS Song Here is a catchy little tune to help you remember the BODMAS order of operations. [youtube http://www.youtube.com/watch?v=Z-FKjqL6NyQ]     Related Items Introduction to Integers Arranging Integers in Order Adding Integers Using Number Lines Adding Integers Using Zero Pairs Subtracting Integers Multiplying Integers Dividing Integers Directed Number Integers Games Integers in the Real World Integers in Drag Racing 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: How Free Subscription Works 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. Free Gift Header If you are a subscriber to Passy’s World of Mathematics, and would like to receive a free PowerPoint version of this lesson valued at $3.99, but 100% free to you as a Subscriber, then email us at the following address:
Email address image Please state in your email that you wish to obtain the free subscriber copy of the “Bodmas / Pemdas Order of Operations” Powerpoint.
Enjoy, Passy ]]>

Share
Posted in Directed Numbers, Integers | Tagged , , , , , , , | Leave a comment

Integers Order of Operations

Bodmas Pemdas Rules In countries like Australia, we use the “BODMAS” or “BOMDAS” Rule for doing maths operations in the correct order.
In the USA, and some other countries, use the “PEMDAS” Rule for doing their maths operations. “Operations” are any of the following: Brackets, Squares, Powers, Square Roots, Division, Multiplication, Addition, and Subtraction. Operations Introduction Consider the following question: 1 + 2 x 5 There are two possible ways of doing this question: the right way, and the wrong way! Bodmas of 1 plus 2 times 5 If you are having trouble thinking about which one is the correct answer, then think about a money sum.
If someone gave you one dollar plus two five dollar notes, then the total would be $11.
It would not be $15. Now consider this next question: 2 + 3 x -4 Again there are two possible ways of doing this question: the right way, and the wrong way. Bodmas Integers wrong and right example We must follow the “Order of Operations” carefully in Mathematics to arrive at correct answers.   BODMAS Video For countries like Australia that use BODMAS, the following five minute video covers how everything works. [youtube http://www.youtube.com/watch?v=kISbq2p8ZOs]     PEMDAS Video For countries like the USA which use PEMDAS, the following ten minute Video explains all of the key concepts. [youtube http://www.youtube.com/watch?v=ClYdw4d4OmA]     Integers Examples   Example 1 : Multiplication and Addition Bodmas Example 1     Example 2: Multiplication and Division Bodmas Example 2     Example 3: Brackets Multiplication and Division Bodmas Example 3     Example 4: Brackets Division and Multiplication Bodmas Example 4       Example 5: Brackets Addition and Subtraction Bodmas Example 5     BODMAS / Pemdas Summary Once you have done a few practice questions, the following should become a lot more familiar. Bodmas Summary     BODMAS Song Here is a catchy little tune to help you remember the BODMAS order of operations. [youtube http://www.youtube.com/watch?v=Z-FKjqL6NyQ]     Related Items Introduction to Integers Arranging Integers in Order Adding Integers Using Number Lines Adding Integers Using Zero Pairs Subtracting Integers Multiplying Integers Dividing Integers Directed Number Integers Games Integers in the Real World Integers in Drag Racing 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: How Free Subscription Works 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. Free Gift Header If you are a subscriber to Passy’s World of Mathematics, and would like to receive a free PowerPoint version of this lesson valued at $3.99, but 100% free to you as a Subscriber, then email us at the following address:
Email address image Please state in your email that you wish to obtain the free subscriber copy of the “Bodmas / Pemdas Order of Operations” Powerpoint.
Enjoy, Passy ]]>

Share
Posted in Directed Numbers, Integers | Tagged , , , , , , , | Leave a comment

Integers Order of Operations

Bodmas Pemdas Rules In countries like Australia, we use the “BODMAS” or “BOMDAS” Rule for doing maths operations in the correct order.
In the USA, and some other countries, use the “PEMDAS” Rule for doing their maths operations. “Operations” are any of the following: Brackets, Squares, Powers, Square Roots, Division, Multiplication, Addition, and Subtraction. Operations Introduction Consider the following question: 1 + 2 x 5 There are two possible ways of doing this question: the right way, and the wrong way! Bodmas of 1 plus 2 times 5 If you are having trouble thinking about which one is the correct answer, then think about a money sum.
If someone gave you one dollar plus two five dollar notes, then the total would be $11.
It would not be $15. Now consider this next question: 2 + 3 x -4 Again there are two possible ways of doing this question: the right way, and the wrong way. Bodmas Integers wrong and right example We must follow the “Order of Operations” carefully in Mathematics to arrive at correct answers.   BODMAS Video For countries like Australia that use BODMAS, the following five minute video covers how everything works. [youtube http://www.youtube.com/watch?v=kISbq2p8ZOs]     PEMDAS Video For countries like the USA which use PEMDAS, the following ten minute Video explains all of the key concepts. [youtube http://www.youtube.com/watch?v=ClYdw4d4OmA]     Integers Examples   Example 1 : Multiplication and Addition Bodmas Example 1     Example 2: Multiplication and Division Bodmas Example 2     Example 3: Brackets Multiplication and Division Bodmas Example 3     Example 4: Brackets Division and Multiplication Bodmas Example 4       Example 5: Brackets Addition and Subtraction Bodmas Example 5     BODMAS / Pemdas Summary Once you have done a few practice questions, the following should become a lot more familiar. Bodmas Summary     BODMAS Song Here is a catchy little tune to help you remember the BODMAS order of operations. [youtube http://www.youtube.com/watch?v=Z-FKjqL6NyQ]     Related Items Introduction to Integers Arranging Integers in Order Adding Integers Using Number Lines Adding Integers Using Zero Pairs Subtracting Integers Multiplying Integers Dividing Integers Directed Number Integers Games Integers in the Real World Integers in Drag Racing 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: How Free Subscription Works 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. Free Gift Header If you are a subscriber to Passy’s World of Mathematics, and would like to receive a free PowerPoint version of this lesson valued at $3.99, but 100% free to you as a Subscriber, then email us at the following address:
Email address image Please state in your email that you wish to obtain the free subscriber copy of the “Bodmas / Pemdas Order of Operations” Powerpoint.
Enjoy, Passy ]]>

Share
Posted in Directed Numbers, Integers | Tagged , , , , , , , | Leave a comment