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.
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
Before you start you need to predict which colour is the most common.
Record your prediction
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.
Enter the results into the spreadsheet
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.
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.
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.
Right click on the bar you wish to change and select Format Data Point.
Select Solid Fill
Click on the down arrow beside Colour and choose the colour you want the Close.
You can get rid of the Legend if you don’t want it by clicking on it then hitting Delete.