If you adjust your configuration slightly, you could use this approach to
select which of several charts appears:

http://peltiertech.com/Excel/Charts/...eDropDown.html (use the Bring To
Front technique)

or this combo box approach to select a series to show in a single chart:

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

Then use this for the date range:

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
_______


"zephyr" wrote in message
...
I have a spreadsheet with six rows 2 to 7 and 12 columns B to M.

Row 2 contains the date. Rows 3 to 7 contains the data.

The data from the cells is used to display a chart on the worksheet.

What I would like to do is

1) have the chart to only appear on a window when a button is pressed
2) when the window appears there will be two boxes start date and end
date.

When the start and end dates are typed in I would like the chart to only
show the points between the two dates. If the start date is not typed in
then
the full range should be displayed automatically.

Could any one advise how this can be made to work, a step by step approach
would be appreciated as I am not a whizz with excel.

Many thanks and any help is appreciated.