If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
pie chart data labels
I'm new to creating charts. I want to create a pie chart
with both percent and value data labels. |
#2
|
|||
|
|||
pie chart data labels
Marilyn wrote:
I'm new to creating charts. I want to create a pie chart with both percent and value data labels. When you get to the third step of the chart wizard (XP), select the Data labels tab and select both % and value check boxes. If you've already created the pie chart, select the chart, go to Chart | Chart Options | Data labels tab. Dave dvt at psu dot edu |
#3
|
|||
|
|||
pie chart data labels
You can calculate the percentages on the worksheet, and use a formula to
create the labels. For example, with the following data in in A1:B3 -- Jan 25 Feb 25 Mar 50 Enter the following formula in cell C1, and copy down to C3: =B1/SUM($B$1:$B$3) To calculate the text for the pie chart labels, enter the following formula in cell D1, and copy down to D3: =B1 & " " & TEXT(C1,"0%") When you create the pie chart, in step 2 of the Chart Wizard, click on the Series tab. Click in the Category Labels box, and then select cells D13 on the worksheet. In step 3, choose Show Label on the Data Labels tab. Marilyn wrote: I'm new to creating charts. I want to create a pie chart with both percent and value data labels. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|