Line chart - 3 lines from one field

[snowsride]

I have a table with a date field and a price field that contains daily records from 1/1/96 to present.

I want to create a line chart that shows the prices for 1999, 2000 and 2001 summarised by month but with a separate line for each year for comparative purposes.

Any ideas?

Thanks

 

[Mario]

Your x-axis will be the months and your y-axis will be the data for each of your years... If you have the same number of data for each year, you can use microsoft graph included in access. If not, you'll have to use Excel (automation).