Smarties Graphing in Excel 2007

1 / 16

Smarties Graphing in Excel 2007 - PowerPoint PPT Presentation

Smarties Graphing in Excel 2007. J. Kellow. The Task. You will be predicting the most common Smarties colour then checking your answer and graphing the results. You will need: 1 packet of Smarties (or M&amp;Ms/Skittles/Pebbles) A plate or clean piece of paper Computer with Excel. Predict.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

PowerPoint Slideshow about 'Smarties Graphing in Excel 2007' - jolene

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Smarties Graphing in Excel 2007

J. Kellow

You will be predicting the most common Smarties colour then checking your answer and graphing the results.

You will need:

1 packet of Smarties (or M&Ms/Skittles/Pebbles)

A plate or clean piece of paper

Computer with Excel

Predict

Before you start you need to predict which colour is the most common.

Excel
• Open Excel from the desktop shortcut

OR

• Go to the Start Menu – Programs – Microsoft Office – Microsoft Excel 2007
Set up the table

List all the possible Smarties colours

Head up the next column ‘No. of Smarties’

Click in a cell to make it ’live’.

‘Enter’ to move to the next cell.

Record Results

Enter the results into the spreadsheet

Create a graph

Highlight the table with the data

Click the Insert Tab

Select the type of graph e.g. Bar

Choose the chart type

The graph will be inserted.

Click on the graph and three new tabs (Design, Layout, Format) will appear under the heading Chart Tools

In the Design menu you can change the chart type, layout and style.

In the Layout menu you can edit the chart title, data labels, axes etc.

In the Format menu you can change how your graph looks – Borders, Word Art styles etc.

Change Bar Colour

Click on one of the coloured bars. This will select all the bars. If you make changes now they will apply to all of the bars.

Change Bar Colour

If you only want to change the colour of one bar then you need to double click on that bar after you have selected all the bars.

The bar you select will have handles (dots) in each corner.

Change Bar Colour

Right click on the bar you wish to change and select Format Data Point.

Change Bar Colour

Select Fill

Select Solid Fill

Click on the down arrow beside Colour and choose the colour you want the Close.

Legend

You can get rid of the Legend if you don’t want it by clicking on it then hitting Delete.