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 - data value & label
I am using Excel 97. Is there anyway on a pie chart to
display the label and VALUE rather than label and PERCENT. |
#2
|
|||
|
|||
Pie - data value & label
You can use a formula to create the label that you want. For example,
with categories in cells A1:A10 and values in B1:B10 -- 1. Enter the following formula in cell C1: =A1 & CHAR(10) & B1 2. Copy this formula down to C10 (ignore the white box that appears in the formula) 3. Select cells B1:B10, and click the Chart Wizard button 4. Select the Pie chart, and one of the pie chart subtypes 5. In step 2 of the Wizard, on the Series tab, click in the Category Labels box, then select cells C1:C10 6. In step 3, on the Labels tab, select 'Show label' 7. Click Finish Anne Zarzycki wrote: I am using Excel 97. Is there anyway on a pie chart to display the label and VALUE rather than label and PERCENT. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Pie - data value & label
Worked great! Thanks!!!!!
-----Original Message----- You can use a formula to create the label that you want. For example, with categories in cells A1:A10 and values in B1:B10 -- 1. Enter the following formula in cell C1: =A1 & CHAR(10) & B1 2. Copy this formula down to C10 (ignore the white box that appears in the formula) 3. Select cells B1:B10, and click the Chart Wizard button 4. Select the Pie chart, and one of the pie chart subtypes 5. In step 2 of the Wizard, on the Series tab, click in the Category Labels box, then select cells C1:C10 6. In step 3, on the Labels tab, select 'Show label' 7. Click Finish Anne Zarzycki wrote: I am using Excel 97. Is there anyway on a pie chart to display the label and VALUE rather than label and PERCENT. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
Thread Tools | |
Display Modes | |
|
|