charts

[Tongaman59]

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?

 

[smartin]

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/files/excel/dynamic_chart_different_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]

Here's a start:

http://vfdrake.home.comcast.net/files/excel/dynamic_chart_different_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.