jeudi 7 septembre 2023

VBA and Graphic - Serie visible or not

in my Chart 1, I'd like - through a CheckBox - to show/hide a series in a graph. However, the below code gives an error application-defined or method-defined. Could somebody help me on fixing it? THanks

If CheckBox1.Value = True Then
Worksheets("Graph").ChartObjects("Chart 1").Chart.FullSeriesCollection.Item(1).IsFiltered = False 



Aucun commentaire:

Enregistrer un commentaire