Change Chart Axis Font Color with a Checkbox

Hi Jason

Sorry my bad, I didn't realize that you used a Form formant not Activex formant.

So, now try this:

Right click on your checkbox, choose "assign macro", then if you have something like Checkbox5_Click on the list select it, choose Edit and then paste this code:

ActiveSheet.ChartObjects("Chart5").Activate

With ActiveChart.Axes(xlValue).TickLabels.Font
    If .Color = RGB(166, 166, 166) Then
        .Color = RGB(0, 0, 0)
    Else
        .Color = RGB(166, 166, 166)
    End If
End With
    
   ActiveSheet.Range("A1").Select  'to deactivate chart

Hope this help you.