Good Afternoon All!
Im stuck again!
I have a bar chart with its values showing.....I would like to have some VBA code which updates the data label depending on the number of decimal places the value is. Ie the first label may be 99.09 and the second 99.10 and the third 98.00
The code should adjust the labels to be 99.09 and 99.1 and 98
Currently My code changes the format to two decimal places:
ActiveSheet.ChartObjects("Chart 14").Activate
ActiveChart.SeriesCollection(3).DataLabels.Select
Selection.NumberFormat = "0.00%"
I guess I need an IF...then ???
Does anyone have anything similar to this???
Thnks
Dani