The is not a chart collection within the activesheet object.

There is for a workbook object. These are the chart sheet type.

If you have chart objects then use the chartobjects collection of the worksheet
With ActiveSheet.ChartObjects("Chart1").Chart.Axes(xlCategory, xlPrimary)