Is there a way to hide/unhide graphs conditionally?

**cooldude_123** · 06-25-2014, 11:49 AM

Hi all,

Is there a way to hide/unhide graphs based on a certain criteria/condition? From what I know you cannot use objects such as graphs in formulas (such as an if statement in this case). What I am looking to do specifically is hide certain graphs from showing if certain data cells in my spreadsheet are blank/zero.

Thank you in advance

**Andy Pope** · 06-26-2014, 04:29 AM

Here is a very simple UDF to make chart object visible or not.

Public Function udfChartVisible(Name As String, State As Boolean)
    On Error GoTo ErrChartVisible
    ActiveSheet.ChartObjects(Name).Visible = State
    udfChartVisible = State
    Exit Function
    
ErrChartVisible:
    udfChartVisible = CVErr(xlErrRef)
    Exit Function
End Function

Change the visible state in cells C3 or C4