Comparing Month vs. Month in an Access Chart (1 Viewer)

themurph2000

Fat, drunk, and stupid
Local time
Today, 05:18
Joined
Sep 24, 2007
Messages
181
I probably should know the answer, but I'm having a brain freeze this morning. (forgot to feed the hamsters on their treadwheels)

I already have an Access Pivot Chart that totals labor costs for jobs in a particular month, and the axis is separated by month. What one of my bosses wants is to be able to have a series be a month from 2008 and another series be from 2009. Then the x-axis would be the respective months (January, February, March, etc.)

The original chart is based on a query that calculates the labor costs and it's data is of the variety...

Date Labor Cost
3/2/08 $145.99
3/4/08 $97.99
4/15/08 $125.84

etc.

Sorry to throw an easy question at you, but I'm stuck and people are breathing down my neck about this.

Thanks.
 

Users who are viewing this thread

Top Bottom