You are going to draw a pie chart showing the number of different kinds of song birds in just 1996.
*** Open the spreadsheet Song Birds.
*** Click in cell A5 and drag down to A13.
*** Hold down the Ctrl button.
*** Click on cell C5 and drag down to C13.
*** Click on the Insert tab.
*** Click on the Chart button.
*** Select the first type of pie chart. You can you can experiment with other types of chart later.
Excel will create your pie chart. We are going to edit it to make is clearer what the chart shows.
*** This first thing we are going to do is give the chart a title. Select the pie chart.
*** You will now see the chart tabs appear at the top ribbon. Select the layout tab.
*** Click on Chart title. Select Above Chart, as that is where we want the chart title to appear.
*** Select the text box.
*** Type Song birds 2012
At the moment there are no data labels
*** Click on the Design Tab on the ribbon at the top.
*** Select the layout with the % sign on the pie chart and the labels to the right of the pie chart.
You will see that the Chart now has a title and labels to make it very clear. However the work sheet looks messy with the two charts on it.
*** Select the chart background area to make the chart tabs appear.
*** Click on Move Chart, a new window will appear.
*** Select New Sheet, and type in “Song Birds 2012” to give the sheet a title.
*** Click on OK. You will now see a tab at the bottom of your spreadsheet has been created for the pie chart.
If you want to move it back to be an object in the spreadsheet just do the reverse. This view may be the best to use if you want to print it out.
*** Click on the tab Sheet 1. This will let you go back to Sheet 1 to see the data and first chart.
*** Save your spreadsheet.