I'm creating a chart via vba from within Access using late binding. I am able to create the chart but the Y axis is displaying the percentage values to 2 places. I tried setting it to "%00" but it is putting adding a zero to the zero value so that it appears like "%00" . I am also trying to display the y value for each bar within their respective bars.
.ChartType = 52
.PlotBy = 2
'.Location where:=2, Name:="Percent Available By Planner"
.HasTitle = True
.HasLegend = True
.Axes(2).TickLabels.NumberFormat = "%00"