I have a database in an excel worksheet that I download from an internet
source.
It's 25 columns by 100 to 150 rows.

I want to plot the value in the "Value" column versus the date in the "Date"
column for each row where the "Status" Column equals "A" in a chart on that
worksheet.

"Value" ranges form 100 to 300, "Date" covers a 2 year window and there are
about 30 (+/-) occurrences of "Status" = "A"

I use the data base functions to find min, max, average but would like some
way to apply the criteria to my graph.

I'm familiar with MS Access & VBA in MS Access and could generate a query
but I want to do this in an Excel application.

Any suggestions would be great!

Thanks,

Jael