Changing chart tick label properties (color, font size, number format) on xlHistogram Chart

[RawlinsCross]

Having a bit of trouble doing basic chart property adjustment. I'm wondering whether it has to do with the chart type itself? From all my searching, the syntax seems correct?

Set myChart = ActiveSheet.Shapes.AddChart2(366, xlHistogram).Chart

With myChart
    .SeriesCollection.NewSeries
    'Histograph can't take array input??
    .FullSeriesCollection(1).Values = wSht.Range("J1").CurrentRegion
    .FullSeriesCollection(1).ApplyDataLabels  
    .HasTitle = False
    .Axes(xlCategory).MajorTickMark = xlOutside
    .Axes(xlCategory).TickLabels.NumberFormat = "0.0" 'This fails
    .Axes(xlCategory).TickLabels.Font.Size = 10 ' This fails
    .Axes(xlCategory).TickLabels.Font.Color = vbBlack 'This fails
    .Axes(xlValue).MajorTickMark = xlOutside
    .Axes(xlValue).TickLabels.Size = 10 'This fails
    .Axes(xlValue).TickLabels.Font.Color = vbBlack 'This fails
End With

 

[rlv01]

Use the macro recorder to record a macro while you are manually making the changes you want. Then inspect the recorded code to see what the syntax should be.

 

[RawlinsCross]

No dice.. macro doesn't record changes. I read somewhere that this is an issue with new graphing tools rolled out in 2016 but I figured I'd ask to see if there had been any update.
Thanks for your suggestion all the same. (First thing I tried)

 

[rlv01]

If it ever was a problem in 2016, they have fixed it. I have Excel 2016/O365 and the macro recorder works for me when I edit chart axes. Btw,

    .Axes(xlCategory).TickLabels.NumberFormat = "0.0" 'This fails
    .Axes(xlCategory).TickLabels.Font.Size = 10 ' This fails

Works just fine for me.

 

[rlv01]

Sorry. My mistake, It just now registered that you are using a histogram chart object, which does not play by the normal rules.