MS Excel 2007 ChartsDelivering a Message

Prof. Donna B. Sanders

Unit #7: Excel Charts Excel Pie Charts

The chart we are about to create is a pie chart.

We are going to use ITV figures on the following slides.

Unit #7: Excel Charts

Type the following date in to your open Excel 2007 document and highlight the ITV data as shown in the image below:

Unit #7: Excel Charts 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.

Unit #7: Excel Charts

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.

Unit #7: Excel Charts 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.

Unit #7: Excel Charts Step 3 of the Wizard looks like this:

Unit #7: Excel Charts 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.

Unit #7: Excel Charts Step 4 of the wizard is where you specify the

location for your new chart. This is the dialogue box:

Unit #7: Excel Charts 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 in the next part of this lesson.

Unit #7: Excel Charts When you click the Finish button after step 4

of the Chart wizard, the wizard closes, and your new chart appears in your spreadsheet.

Unit #7: Excel Charts

Your new chart will have the black squares surrounding it, indicating that it is selected.

Click anywhere on a white area (Top left corner of the chart is ideal).

Hold down your left mouse button and drag the chart downwards into some space.

Unit #7: Excel Charts When you have moved the chart, you need to

resize it. Hold down your left mouse button on the centre black square at the bottom. Drag downwards to increase the height of your chart. When you have finished, you should have a pie chart on your spreadsheet like the one below:

Unit #7: Excel Charts

Unit #7: Excel Charts If part of your title "Viewing figures in

millions" is hidden, you can move it over. Click on your title with your left mouse button. You'll see a border appear around the title:

Click on the shaded border with your left mouse button. Keep your left mouse button held down and drag it to a different position.

Unit #7: Excel Charts

And that's it for pie charts. Except we need some of that space that the pie chart is occupying. And the chart is a bit hard to see where it is.

It would be better of in a sheet of its own. We can move it.

Unit #7: Excel Charts Make sure the chart is highlighted by clicking

on it with the left mouse button. The black squares should appear around the edges

Click on Edit from the menu bar From the drop down menu, click "Cut" The chart disappears from the spreadsheet

Unit #7: Excel Spreadsheets

Click on a blank Sheet at the bottom (Sheet 3 might be blank on yours, but the image shows Sheet 4)

Unit #7: Excel Spreadsheets Click on Edit from the menu bar From the Drop down menu, click on Paste The pie chart is pasted to Sheet 3

Unit #7 Project Scenario Now that you have successfully set up your

personal budget, formatting it to look professional, and added

some formulas and functions to be able to analyze your overall income and expenditures, now you will be

adding a pie chart to visually display your expenses.

Using only your Monthly expense labels and your Annual expense totals, create a Pie Chart on a new

worksheet that will show how you are spending your money.

Unit #7 Project

Step 1: Highlight the appropriate data and create the pie chart and add that chart to a new worksheet.

Step 2: Add Data labels to your Pie Chart Step 3: Ensure you also have percentages

showing on your Pie Chart Step 4: Add a title to your Pie Chart Step 5: Rename the worksheet tab to Pie

Chart. FINAL Step: Save your workbook and

submit it to the appropriate dropbox.

Unit #7 Seminar THANK you for attending

the Unit #7 Kaplan Higher Education Live Seminar.

I appreciate our time together and look forward to it every week.

You are free to leave – see you next week!!!

THE END!!!