Hide a Chart with Form Control Buttons

Hello,

I have a sheet with 4 charts, how do I hide of the chart using form control button?

My intention was to hide 3 pie charts when I click a button, and show only line graph, and another button to reverse it.

I am not sure whether this question belongs to VBA threads or this one.

Thank you, please find the sample file attached.

Originally Posted by Andy Pope

Add code to standard code module.

Sub Button1_Click()
    With ActiveSheet
        .ChartObjects("Chart 1").Visible = True
        .ChartObjects("Chart 2").Visible = False
        .ChartObjects("Chart 3").Visible = False
        .ChartObjects("Chart 4").Visible = False
    End With
End Sub
Sub Button2_Click()
    With ActiveSheet
        .ChartObjects("Chart 1").Visible = False
        .ChartObjects("Chart 2").Visible = True
        .ChartObjects("Chart 3").Visible = True
        .ChartObjects("Chart 4").Visible = True
    End With
End Sub

Assign one macro to each button

I tried this but without using With/End With function, and it failed. Thank you for the code!