Multi-view selections in one chart.

[joey31]

Here is my goal... I would like to be able to select a pull down with
sorta lookup of e.g A, B, C, etc. program which reside on differen
tabs and be able to select program A and the chart shows stats for A
Next go to pull down and select B to see B's stats and so on. All whic
will show up on one chart. I would also like to be able to have
selection to show all A, B and C in one image on the chart as
summary. I am not strong at VB but understand code. I have created
summary and each individual chart as needed but would like it to rollu
into one chart.
Any ideas?? :eek

 

[Jon Peltier]

Joey -

You could adapt the technique shown here:

http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html#SheetControls

which allows you to check a checkbox for each series you want to display
in the chart.

- Jon