M
Motaad
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
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