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

Courtney,

Right-click any of the labels, and select "Format data labels" and set the number format through the
dialog. That will change all the labels.

HTH,
Bernie
MS Excel MVP


"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