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

  • Thread starter Thread starter Craig Buchanan
  • Start date Start date
C

Craig Buchanan

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.
 
Back
Top