I have a large data set that I want to be able to chart interactively. I
have set up combo boxes to change my state location(Id., Mt., UT, etc), my
acct. type(new, existing), and my product type(silk, cotton, etc .).
Everytime I change the three of them (all in separate combo boxes) I want to
automatically change to the data range that contains that particular data. I
went to some selected websites on the issue but they no longer seem to be
there (pertiertech.com/excel/chartbycontrol.html). Any suggestions how to
set up the interactive charts
--
Motaad