Pie Chart

[Jason]

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

[Tushar Mehta]

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 <[email protected]>,
[email protected] 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
>

[Peter Huang [MSFT]]

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.