Charts - with Crosstab and totals

[Eric]

This may be a two part question, but I'll try it anyway.

I have a table of Revenue by Date. It is a 1:M relationship based to
salesperson. What I need to get is a chart that shows 3 years by Current
Quarter. e.g. 2006Q1, 2007Q1 and 2008Q1.

I can get the select query or the crosstab query to pull this information
based on date and I can control which quarters are show.

The problem is How do I get Grand Totals to appear in the chart and change
the datapoints when the next quarter is ready?

Thanks.