To add % signs, add them to the numbers in the table (as shown below). The labels that appear will match those in the table.
![how to make a pie chart in excel 2003 how to make a pie chart in excel 2003](https://www.officetooltips.com/images/tips/184_2010/8.png)
To show the percentages on the chart, right click on the pie, then left click on Add Data Labels. Left click on Format Legend - this gives a menu that lets you put the key in a different place. The Nuffield Foundation 2ģ To change the size or style of the key (legend), right click on it - this gives the menu shown below. To undo anything you don t like left click on the Undo button. If you have time, experiment with other ways of changing the title. To reduce the size of the title, right click on it, then left click on the arrow next to the font size. The size of this title will probably be too big.
![how to make a pie chart in excel 2003 how to make a pie chart in excel 2003](https://www.officetooltips.com/images/tips/182_365/3.png)
Left click on Edit Text and change the title to Travel Agent s Holiday Sales in Europe. To improve the chart title, right click on it - this gives the menu shown. Often a right click on something on the chart gives a menu. There are many ways to change what your pie chart looks like. Use handles at the corners to change the size in both directions. Use handles on the sides to change the size in one direction. The Nuffield Foundation 1Ģ To change the size of the pie chart, left click on one of the handles and at the same time drag the mouse. To move the chart left click on it and at the same time drag the mouse. Left click on Insert, the arrow below Pie, then the first 2-D Pie A pie chart will appear. Remember to save your spreadsheet regularly so that you do not lose any work. Choose a name like Travel Agent Pie to help you remember what it is. This table gives the % of European holidays sold by a travel agent in different countries in Europe. Enter some data you can use your own data if you wish.
#How to make a pie chart in excel 2003 how to#
1 This activity shows how to draw pie charts in Excel Open a new Excel workbook.