Ok, I know some one will be able to help me. I need to create a chart that is
based off of 26 sheets give or take 3 or 4, this chart needs to be an advance
skill level when mine is only intermediate. I need the chart to not only self
expand, but I need it to also contain drop down menus, to make selection on
what should show on the chart. I need to have at least 3 different drop
downs, with up to 7-10 choices in each. I also need help on how to create a
table that allows subcatagories in it. Such as a section named Falls needs to
have 7 subsections numbered 1.1,1.2,1.3...etc...how do I make all of this
work??? I need some serious help!!!
> Ok, I know some one will be able to help me. I need to create a chart
> that is based off of 26 sheets give or take 3 or 4, this chart needs
[quoted text clipped - 6 lines]
> subsections numbered 1.1,1.2,1.3...etc...how do I make all of this
> work??? I need some serious help!!!
I think a good starting point could be a pivot chart, i.e. a chart based on
a pivot table...
In Excel 2003, and if I well remember also with Excel XP, you have the
option to make a pivot chart when you choose menu Data, Pivottable And
Pivotchart Report...

Signature
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
smiles - 25 Aug 2006 20:29 GMT
> > Ok, I know some one will be able to help me. I need to create a chart
> > that is based off of 26 sheets give or take 3 or 4, this chart needs
[quoted text clipped - 13 lines]
> option to make a pivot chart when you choose menu Data, Pivottable And
> Pivotchart Report...