Microsoft KB Archive/279199

= HOW TO: Include Both Value Labels and Percentage Labels on a Pie Chart in Excel 2000 =

Article ID: 279199

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q279199



IN THIS TASK
SUMMARY
 * Add Value Labels to a Pie Chart That Uses Percentage Labels



SUMMARY
In Microsoft Excel, you can add value labels or percentage labels, but not both, to a pie chart. This article explains how to manually add value labels to a pie chart that uses percentage labels.

back to the top

Add Value Labels to a Pie Chart That Uses Percentage Labels

 * 1) Click the chart to select it.
 * 2) In the formula bar, type =, where   is a cell reference to a point of data in the pie chart. For example, type =Sheet1!B2 . Press ENTER.

The data label appears in the center of the chart.
 * 1) Drag the data label to the appropriate location on the chart.
 * 2) Repeat steps 1 through 3 for each point of data in the pie chart.

NOTE: Because the data labels are fixed objects in the chart, if the pie chart is dynamic and the data changes, you must move the labels to reflect the changed data.

back to the top

Additional query words: XL2000

Keywords: kbhowtomaster kbchart KB279199

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.