I'd like to create a Master Chart - with a drop down box to chart the data
from 76 different tabs (one at a time). How would I start to get that done?

Tongaman59 wrote:
I'd like to create a Master Chart - with a drop down box to chart the data
from 76 different tabs (one at a time). How would I start to get that done?


Here's a start:

http://vfdrake.home.comcast.net/file...worksheets.xls

There are a few obvious and not-so-obvious things you need to know to
manage this:

- Add your sheet names in Chart! column A (blue text). The combo box
should automatically update choices as you add/remove sheet names here.
- Fill down formulas in Chart! columns B:E (green text).
- Assumes charting data is cornered at A1 of worksheets -- but cell A1
is blank. Follow the examples. Place desired chart labels in F2 of data
sheets.
- Named ranges contain dynamic formulas that drive the chart.

Hope this helps!

smartin wrote:
Tongaman59 wrote:
I'd like to create a Master Chart - with a drop down box to chart the
data from 76 different tabs (one at a time). How would I start to get
that done?


Here's a start:

http://vfdrake.home.comcast.net/file...worksheets.xls


There are a few obvious and not-so-obvious things you need to know to
manage this:

- Add your sheet names in Chart! column A (blue text). The combo box
should automatically update choices as you add/remove sheet names here.
- Fill down formulas in Chart! columns B:E (green text).
- Assumes charting data is cornered at A1 of worksheets -- but cell A1
is blank. Follow the examples. Place desired chart labels in F2 of data
sheets.
- Named ranges contain dynamic formulas that drive the chart.

Hope this helps!

There was a problem with the file I initially uploaded. Excel balked
because the combo control was embedded in the chart. I corrected the
problem and uploaded a version that actually works.

Sorry for any confusion.