View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Chart select, yet changing set of series

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