Here are a couple ways:

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

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


"Carlee" wrote in message
...
Hi All,

I have a bar graph that shows the following information
X Axis = Date
Y Axis = Copper Produced

Question: How can I enable the user to select a month from a drop-down
list
and the chart show the data only for the selected month?

--
Carlee