Excel Pie Charts
- The next chart we'll create is a pie chart. The process is almost the same, but instead of creating the chart in a separate sheet, we'll create it in the spreadsheet itself. This time, we'll use the ITV figures.
To make a start on the pie chart, highlight the ITV data in the spreadsheet you created earlier, as in the image below:
Once the data is highlighted, click on Insert from the menu bar. From the menu, click Chart. Alternatively, click the Chart icon in the toolbar. The chart icon looks like the one below:
If you can't see that icon in the tool bar, click on View > Toolbars. From the menu that appears, make sure there is a tick next to Standard.
Whichever method you use, the Chart Wizard will start up again.
In step 1 of the Wizard, locate the word Pie in the Chart Type list. The pie chart sub-types appear just to the right. There are six sub-types to choose from. Select the first one.
You can click the "Press and Hold to View Sample" button to see what it looks like. But click Next when you're done.
Step 2 of the Wizard is for the data range to include in the Pie chart. We've already selected our data, so just click the Next button on Step 2.
Step 3 of the Wizard looks like this:
Click inside the Chart Title text box, and enter the title "Viewing Figures in Millions". Then click the Data Labels tab strip.
Under "Data labels", the default value None will be selected. Click "Show value" instead. (But click the others and see what happens). Then click the Next button at the bottom.
Step 4 of the wizard is where you specify the location for your new chart. This is the dialogue box:
Make sure your dialogue box has "As object in" selected, and it says Sheet 1 (This is where your spreadsheet should be. If it's in a different sheet, click the black down arrow and select the sheet you need.)
Next, click the Finish button at the bottom. We'll see what happens inthe next part of this lesson.
Comments
Post a Comment