Another way which sounds like what you want is to have your data with a tog=
gle button above each column which you click if you want that series to app=
ear. You can do this by actually graphing a dummy series. Say that the re=
al data is in in B3:B10 and you have a toggle button which puts a TRUE into=
B1 if you want the series to be plotted (otherwise a FALSE). Put the dumm=
y data over in say F3:F10. F3 reads =3Dif($B$1,B3,#n/a) and copy this down=
. This is the data you plot. If B1 =3D TRUE then the graph is visible. i=
f B1 =3D FALSE the the graph disappears. Repeat for the other columns.=20
To put a toggle button in for Excel 2007, you will need to go into options =
and get the Developer pane visible. It probably already is if you are writi=
ng macros. Then Developer - Controls - Insert - ActiveX - Toggle Button - d=
rag and outline - right click - Properties - Linked Cell B1 -=20
Design Mode off.
Or, send me a copy of the sheet as it is to the.christies at clear.net.nz a=
nd I will give you an example.