Kathy -

You need to make labels in the sheet, then apply them to the chart.

If your chart data is in C2:C5, select D2:D5 and type this formula:

  =C2&" ("&TEXT(C2/SUM(C$2:C$5),"0.0%")&")"

and don't press Enter. Instead hold down Ctrl while pressing Enter.
Holding Ctrl puts the formula into the entire selected range. The
formula gives you the value and the percentage in 0.0% format.

Now get ahold of one of these free chart labelers:

  Rob Bovey's Chart Labeler, http://appspro.com
  John Walkenbach's Chart Tools, http://j-walk.com

These let you choose the chart and series, then indicate which worksheet
range holds the labels. It does the rest.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Kathy,

If you have Windows 2000 here is an easy way to shoow the value an
percentages on your chart:

1. click on a slice in your pie chart
2. choose "format data labels"
3. choose "data lables" tab
4. check the "value" and "percentage" boxes
5. click "ok

--
Message posted from http://www.ExcelForum.com