smarties graphing in excel 2007 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Smarties Graphing in Excel 2007 PowerPoint Presentation
Download Presentation
Smarties Graphing in Excel 2007

Loading in 2 Seconds...

play fullscreen
1 / 16

Smarties Graphing in Excel 2007 - PowerPoint PPT Presentation


  • 130 Views
  • Uploaded on

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&Ms/Skittles/Pebbles) A plate or clean piece of paper Computer with Excel. Predict.

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

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


An Image/Link below is provided (as is) to download presentation

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
the task
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&Ms/Skittles/Pebbles)

A plate or clean piece of paper

Computer with Excel

predict
Predict

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

Record your prediction

excel
Excel
  • Open Excel from the desktop shortcut

OR

  • Go to the Start Menu – Programs – Microsoft Office – Microsoft Excel 2007
set up the table
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
Record Results

Enter the results into the spreadsheet

create a graph
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

edit your graph
Edit your graph

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.

edit your graph10
Edit your graph

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

edit your graph11
Edit your graph

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

change bar colour
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 colour13
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 colour14
Change Bar Colour

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

change bar colour15
Change Bar Colour

Select Fill

Select Solid Fill

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

legend
Legend

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