The Nuffield Foundation 4ĥ Other ways of changing your pie chart You can also use the buttons and menus at the top of the spreadsheet to change things. Remember that to undo anything you don t like just left click on the Undo button. Usually a right click on any part of the chart gives you a menu of things you can try. If you have time, experiment with other changes. The labels may move if you change the size of the pie or labels. This option lets Excel choose the best position. When other values are used, a left click here changes the labels to percentages. Note The data used in this activity is already in percentages. For example, this option gives labels inside the pie at the ends of the sectors. Left click on the position you like best. 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. If the pie is big and the font size small, the labels may move onto the pie (as shown below). To increase the size of the pie, left click on one of the handles and at the same time drag the mouse. The Nuffield Foundation 3Ĥ 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 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. To add % signs, add them to the numbers in the table (as shown below). The labels that appear will match those in the table. 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. 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 DO I MAKE A PIE CHART IN EXCEL 2007 HOW TO#
1 This activity shows how to draw pie charts in Excel Open a new Excel workbook.