How to graph between two dates

[ohisofly]

I have a database with three columns: Date, Sales and Quantity.

The user will enter the start and end date into two separate cells, and then I would like the graph to automatically show data only between those two dates.

I came across the answer below but am having trouble understanding how this works; when I enter this formula I get '#VALUE!'

-----------------------------------------------------------------------------------------------------------------------------------------

Use a defined name such as this (dateseries) to match the dates in column A
ONE line in the refers to box

=OFFSET(Sheet24!$A$5,MATCH(Sheet24!$B$4,Sheet24!$A:$A)-5,0,MATCH(Sheet24!$B$5,Sheet24!$A:$A)-MATCH(Sheet24!$B$4,Sheet24!$A:$A)+1,1)

then use that defined name in your series. =workbookname!dateseries
Now when you change b4 as your start date and b5 as your end date your chart
will auto create

[jstn]

Can you post a sample file with what you're after?