Graph of prices by date with each year as a separate line

I would like have a line graph that displays prices (Y axis) for each
recorded date (X axis), displaying each year's data as a separate line.
Essentially, I want to see how a stock price changes each day and be able to
compare these values year to year.

Seems like this would be fairly easy to do, but I must be missing something.

thanks in advance,

craig buchanan

I expect you could use a crosstab query with Year(StockDate) as the Column
Heading.

--
Duane Hookom
Microsoft Access MVP


"Craig Buchanan" wrote:

I would like have a line graph that displays prices (Y axis) for each
recorded date (X axis), displaying each year's data as a separate line.
Essentially, I want to see how a stock price changes each day and be able to
compare these values year to year.

Seems like this would be fairly easy to do, but I must be missing something.

thanks in advance,

craig buchanan