Configuring a pie chart in Microsoft ExcelYou can use data you have entered into a spreadsheet to create a wide variety of charts that gives a graph representation of the information in your sheet. One of the more popular charts used in Excel is the pie chart. It presents that data in a user-friendly format, and is often used when comparing percentages. To begin making and configuring a pie chart, first select the area of your spreadsheet you want Excel to use for the chart:
To continue, click on the Chart Wizard icon in the toolbar:
The Chart Wizard opens, and provides you with a range of chart styles to choose from. Click on Pie and then click Next.
The next step gives you a preview of what your pie chart will look like. Click Next and you will enter the chart options. Enter your chart title:
Click on the Data Labels tab. You can check Label Contains options to configure the way your chart will appear:
Click on Next and then click Finish. Your chart will appear in your spreadsheet:
Back to Microsoft Excel Assistance 5/07 |
||||||||||||||||||||||