Hi, this is my first post, so please bear with me. I have created some VBA code that creates a little over one hundred pie charts. The data labels look great in most instances, displaying the percentages to one decimal point (to avoid labels showing 0%), but on a few of the charts, if the value is an even number, it displays as, for example, 31.%. The line of code is below:
[vba]
ActiveChart.SeriesCollection(1).DataLabels.NumberFormat = "##0.#%"
[/vba]
If I change the format to "##0.0#%" or "##0.#0%", then the formatting changes to two decimal places (30.98%), which solves the problem, but not in a way that I want. How can I get the example value to display as 31.0%?
I have looked, but have been unable to find any help which explains what these strange formatting symbols mean.
Thanks,
Dave