Not sure if anyone else has run into this issue. The modern charts clustered bar (was what i found this issue on) if the X axis displays a date range and that date range is fixed as month or year or day or quarter and the form is saved then if you have a method that you call in some way that tries to change the dates type (from say month to day or year to month) then this will not action. it runs; but does not actually do anything. If you design the form and change the graphs date range to "None" instead of day,month year.... then when you run your change axis function it works. Design? Bug? the function command by the way is Me.{chart name here}.ChartAxisCollection(0).GroupType = acDateGroupDay