Access Graphs or Charts - Can This Be Done

[q582gmzhi]

Hi,

I have set-up a report suite that uses Access Graphs to display the data on a month by month basis, these works fine.

However the powers that be, now want a YTD version of the same report.

Example:

Month Report: (Already up and running and works fine)
Jan 10 Units
Feb 16 Units
Mar 10 Units

YTD Graphs: (This is what I need to create below)
Jan 10 Units
Feb 13 Units (Jan+Feb/2 Months)
Mar 11 Units (Jan+Feb+Mar/3 Months)

Sounds easy but I need the graph line to mirror the above data.

I have created the months graphs using crosstab queries for the data and it works but I can't get my head round how to get the crosstab to show YTD for each month?

Any advise welcome

Thanks in advance

Darrell...