Data labels for charts

  • Thread starter Thread starter Courtney
  • Start date Start date
C

Courtney

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
 
Back
Top