The solution offered by Kelly is fantastic but this may be easier.

from forms toolbox
The checkbox is linked to cell c4,etc
Just add more for each column that needs to be involved.
right click sheet tabview codeinsert this.
Private Sub Worksheet_calculate()
'put =now()somewhere on the sheet of the chart
With Sheets("data")
.Columns.Hidden = False
If Range("c4") = False Then .Columns(2).Hidden = True
If Range("c5") = False Then .Columns(3).Hidden = True
End With
End Sub

from control box
Private Sub CheckBox1_Click()
If CheckBox1.Value = False Then _
Sheets("data").Columns(2).Hidden = True
End Sub
--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
Easy enough to just hide the column of the data

--
Don Guillett
SalesAid Software

"name" wrote in
message ...

How can I have a chart that *only* plots series chosen by the user. For
example:

I would like to have a on/off (1/0) switch for each series of data. I
want the chart to only plot series with the on switch value. Also, I'm
looking for a true solution, not one that plots the off series on the
axis.

All help is, as always, greatly appreciated.


--
name
------------------------------------------------------------------------
name's Profile:
http://www.excelforum.com/member.php...o&userid=34115
View this thread:
http://www.excelforum.com/showthread...hreadid=559455