View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Courtney[_2_] Courtney[_2_] is offline
external usenet poster
 
Posts: 4
Default 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