Hi,

I take it you have custom data labels, because the regular ones showing
Value, Series Name, ... update to reflect the data range. If you have
customized your data labels manually, then instead of entering data into the
data labels create references to spreadsheet cells, this must be done
manually. Suppose the data labels you want are in the range D1:D5 then
select the first data label and type = on the formula bar and click on cell
D1 and press Enter. Repeat this for all the data labels.

A number of people have created Excel add-ins to do this for you: Google
"Excel Chart Labeler"
--
Thanks,
Shane Devenshire


"Jennifer" wrote:

Is there a way in Excel 2003 to update data labels in existing Pie Charts.
Everytime I run a new report I have to delete old data labels and then format
my labels as needed. Typically the format I use is label value (%).