IF Statement for selecting chart data source

[MBel1]

Hi,

I have got a chart with several series on it. One of the series I would only like to be shown when cell B2 reads "On".
I have set up a data validation in B2 already (On/Off).

I was wondering if there was a way to get this series to plot/not plot depending on the value in cell B2.
I have tried along the lines of: =if(B2="On",H4:H40,0) in the 'X value' box when selecting chart data but this doesn't work.

Any suggestions greatly appreciated!
Thanks.

[romperstomper]

You'll need to put that into a defined name, then use the name in the chart dialog.

[MBel1]

Got it working now, thanks!