Thread: Dynamic graph
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TFriis TFriis is offline
external usenet poster
 
Posts: 22
Default Dynamic graph

Hi Excel Gurus.

I would like to make a dynamic graph-plot - the dynamic part consists
of buttons next to the graph plot, where you can turn certain plots
"on and off".

As I vision it the sheet would count number of series (these are
already dynamic), then create -according to the number of series-
buttons for the graph, and name the buttons according to the name of
the reference series.

When you click the buttons, the plot should update and either add or
remove the specific set of series. (preferably without an extra update
button).

Any input would be great, since this is a bigger project :)