You could filter the data source, because a chart only shows unhidden cells
by default.

Or you could define dynamic ranges that include only the month in question:

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

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


"WH99" wrote in message
...
I have data that covers the whole year. I am trying to create a line graph
for which ever month is selected. The data is layed out as follows:

Col A date
Col E data
Cell D1 dropdown list with the months of the year.

What formular would I use in the source data of a graph to only show
figures
for a particular month?
--
WH99