Scrolling 12-Month Graph - How Do I...

[Cals via AccessMonster.com]

All,

I have a chart that I designed based on the following fields...

MonthYear (text) - denotes month/year for group-by
Application - name of application to group-by
NumberOfEvents - Summary Total for "sum"

I have over 2 years worth of data from this project, which I inherited from
my hiring.
I need my chart/graph to display the current month and then the 12-month
period behind it

(ex. May 2005 - May 2006) In 12 columns for each month (basically a year
graph).

What I need this to do is be a scrolling graph that will only show the prior
12 months
when a new month of data is added to the project - when the June data
arrives,
I want June 2005 - June 2006 in 12 columns.

Anyone have any idea how to set this up so it can be a "scrolling" graph
based on the
month data that is entered?

If I need to be clearer, please let me know

Thanks in advance.

Cals

 

[Duane Hookom]

If would help if there was a date field or derived date that you could use
to apply a criteria. We really don't have any idea how you are calculating
or storing the MonthYear.