Data labels for charts
 

Hi,
I have charts that are based on dynamically populated data. I need
the
data labels for all of these charts to appear with 0 decimal places.
The dynamic data populates with 2 decimal places (X.XX). Is there a
universal setting I can apply to the worksheet or even the chart
itself, so I do not have to go to each data point/data label and set
the formatting to 0 decimal places?
Thanks,
Courtney

Data labels for charts
 

Select the labels, press Ctrl+1 (numeral one) to open the Format dialog, and
on the Number tab, uncheck the Linked to Source box and select the format
you want.

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


"Courtney" wrote in message
...
Hi,
I have charts that are based on dynamically populated data. I need
the
data labels for all of these charts to appear with 0 decimal places.
The dynamic data populates with 2 decimal places (X.XX). Is there a
universal setting I can apply to the worksheet or even the chart
itself, so I do not have to go to each data point/data label and set
the formatting to 0 decimal places?
Thanks,
Courtney