I have Excel 2000. I am trying to create a pie chart that displays both the
percentage and the value. However, there is not a radio button to select
that.

Any suggestions?

Jason

Put the desired result in separate cells in another column. Use a formula
to put together whatever pieces of data you want (use CHAR(10) to force a
"new line," if desired).

Now, get XY Chartlabeler from www.appspro.com and use this new column as the
datalabel source.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have Excel 2000. I am trying to create a pie chart that displays both the
percentage and the value. However, there is not a radio button to select
that.

Any suggestions?

Jason

Hi Jason,

You may try the steps below to see if that what you want?
1. Assume I have a Excel Sheet with value as below.
1
2
3
2. Select the three cells and click Insert/Chart
3. Select the Pie type, Next
4. Next
5. Click Data Lables, and check Value/Percent
6. Click fininshed

Is that what you want?



Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.