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

Hi Motaad,

Try the 'Reporting' sample at
http://www.edferrero.com/ExcelCharts...2/Default.aspx

Ed Ferrero
www.edferrero.com

Case sensitive URL:

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Motaad" wrote in message
...
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