Thanks for responding guys. Worked very well Jon. Can't thank you enough.

"Jon Peltier" wrote:

More examples, though Juice's is pretty nice:

http://peltiertech.com/Excel/Charts/ChartByControl.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=246
http://peltiertech.com/Excel/Charts/ParallelCoord.html

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


"Del Cotter" wrote in message
...
On Sat, 8 Mar 2008, in microsoft.public.excel.charting,
said:
Is it possible to have the range for the source data for a chart
change when a value is changed in a drop-down menu.

Have a look at this article:

http://www.juiceanalytics.com/
writing/2007/05/why-make-100-charts-when-one-will-do/

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.