How can i create pie chart in excel sheet ?

select the table (one column contains label and another column data)

select <Insert> <PieChart> from the menu

you select the pie type as per your requirement

[Pie chart will be created]

Rightclick the chart and select <Add Data labels>

select datalabels and rightclick <Format data labels>

In Label options, select category name, value, percentage and

in seperate option, select <new line>

The relevant details for the chart is displayed

Remove the Legend

Your chart appears better

1. Select all of your data. To do so, click the A1 cell, hold down ⇧ Shift , and then click the bottom value in the B column. ...
2. Click the Insert tab. It's at the top of the Excel window, just right of the Home tab.
3. Click the "Pie Chart" icon. ...
4. Click an option. ...
5. Customize your chart's appearance

· Open a new Excel workbook.

· Enter some data – you can use your own data

if you wish. This table gives the % of

European holidays sold by a travel agent in

different countries in Europe.

· Save your spreadsheet. Choose a name like

Travel Agent Pie to help you remember what it is.

Remember to save your spreadsheet regularly

so that you do not lose any work.

· Highlight the table.

· Left click on Insert, the arrow below Pie, then the first 2-D Pie

A pie chart will appear.

· To move the chart left click on it and at the same time drag the mouse.

Draw pie charts in Excel

A Resource for Free-standing Mathematics Qualifications Draw pie charts in Excel

Ó The Nuffield Foundation 2

Photo-copiable

· To change the size of the pie chart, left click on one of the handles and at the

same time drag the mouse.

There are many ways to change what your pie chart looks like.

Often a right click on something on the chart gives a menu. Try the following.

· To improve the chart title, right click on it

- this gives the menu shown.

· Left click on Edit Text and change the title

to ‘Travel Agent’s Holiday Sales in Europe ’.

The size of this title will probably be too big.

· To reduce the size of the title, right click on it, then left click on the arrow next to

the font size. Now left click on a smaller size.

· If you have time, experiment with

other ways of changing the title.

To undo anything you don’t like

left click on the Undo button.

Use handles on the

sides to change the

size in one direction.

Use handles at

the corners to

change the

size in both

directions.

A Resource for Free-standing Mathematics Qualifications Draw pie charts in Excel

Ó The Nuffield Foundation 3

Photo-copiable

· To change the size or style of the key (legend), right click on it

- this gives the menu shown below. Change the font size if you wish.

· Left click on Format Legend

- this gives a menu that lets you

put the key in a different place.

Left click on Bottom, then Close.

The key will move under the chart.

· To show the percentages on the chart, right click on the pie, then left click on

Add Data Labels. The labels that appear will match those in the table.

· To add % signs, add them to the numbers in the table (as shown below).

· To change the size or style of the labels, right click on one of them

use the menu to change the font size or colour if you wish.

A Resource for Free-standing Mathematics Qualifications Draw pie charts in Excel

Ó The Nuffield Foundation 4

Photo-copiable

· To change the size or position of the pie,

right click just outside of it – this gives a box

around the pie (as shown).

To increase the size of the pie,

left click on one of the handles

and at the same time drag the mouse.

If the pie is big and the font size small,

the labels may move onto the pie

(as shown below).

· To fix the position of the labels,

right click on one label, then

left click on Format Data Labels

The menu shown below will appear.

Left click on the position you like best.

· If you have time, experiment with other changes. Usually a right click on any

part of the chart gives you a menu of things you can try.

Remember that to undo anything you don’t like

just left click on the Undo button.

For example, this

option gives labels

inside the pie at the

ends of the sectors.

Note

The data used in this activity is

already in percentages.

When other values are used, a

left click here changes the

labels to percentages.

This option lets Excel

choose the best position.

The labels may move if

you change the size of

the pie or labels.

A Resource for Free-standing Mathematics Qualifications Draw pie charts in Excel

Ó The Nuffield Foundation 5

Photo-copiable

Other ways of changing your pie chart

You can also use the buttons and menus at the top of the spreadsheet to change things.

Some menus give alternative ways to make the changes that you have already made.

Some buttons and menus allow you to do other things.

Try some of the following – in each case, left click on the chart before you start.

Left click on the Undo button to remove any effects you do not like.

· To change the type of pie chart, left click on Change Chart Type.

Scroll down, then left click on the type of pie chart you want.

· To change the layout of the chart, left click on Chart Tools Design, then choose

one of the other Chart Layouts.

· To change the colours on the pie chart, you can use one of the Excel designs.

To see the full range, left click on Chart Tools Design, then the arrow at the bottom

Change

Chart

Type

Scroll

down

here

A Resource for Free-standing Mathematics Qualifications Draw pie charts in Excel

Ó The Nuffield Foundation 6

Photo-copiable

· To change the colour of a sector of the pie chart, left click the pie, then left click

the sector that you want to change – select handles will appear around the sector.

Left click Chart Tools Format, then the arrow next to Shape Fill.

Left click one of the colours.

·

· To change the colour or thickness of the line around a pie chart or one of its

sectors , left click the pie (then the sector if that is what you want to change).

Left click Chart Tools Format, then the arrow next to Shape Outline.

Left click a colour or weight.

·

· To change the colour of the background or the line around it, left click an empty

part of the chart. Left click Chart Tools Format, then the arrow next to Shape

Fill or Shape Outline – these give the choices shown above.

· If you have time, use other data and experiment with buttons and menus to see the

wide range of pie charts you can create with Excel.

select

handles

Weight gives

different thicknesses

of line

Dashes gives

different styles

A Resource for Free-standing Mathematics Qualifications Draw pie charts in Excel

Ó The Nuffield Foundation 7

Photo-copiable

Units Foundation Level, Making sense of data

Intermediate Level, Handling and interpreting data

Advanced Level, Using and applying statistics.

Skills used in this activity:

· drawing pie charts in Excel

Preparation

Students will need to have some basic knowledge of computer terminology and the use of

computers (eg how to use the mouse and menus in Excel 2007).

Notes

Pages 1 – 4 show how to draw a pie chart and then how to make a variety of changes using right

clicks. Other changes using the menus at the top of the spreadsheet are shown on pages 5 & 6.

Using the Word version of this activity will allow you to change the wording or to reduce or

increase the number of methods shown. For example, with less able students you may decide to

concentrate on just some of the methods used on pages 1 – 4 and simplify some of the wording.

Note that this activity is also available for use with Excel 2003. Another activity called ‘Pie

Charts’ shows students how to draw pie charts by hand. This resource contains lots of other data

that could also be used for extra practice in Excel.