Multi-view selections in one chart.

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Joey -

You could adapt the technique shown here:

http://www.geocities.com/jonpeltier...l#SheetControls

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

joey31 wrote:

> Here is my goal... I would like to be able to select a pull down with a
> sorta lookup of e.g A, B, C, etc. program which reside on different
> 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 which
> will show up on one chart. I would also like to be able to have a
> selection to show all A, B and C in one image on the chart as a
> summary. I am not strong at VB but understand code. I have created a
> summary and each individual chart as needed but would like it to rollup
> into one chart.
> Any ideas??
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>