Help with chart design

T

Todd_Calhoun

I'm going crazy trying to figure out how to do a specific chart.

I want to compare the workflow between different months from a client. I
have a table in which I enter each project when it arrives.

I can make charts that show the workflow over the course of a year (a line
or bar graph with months across the bottom, total numbers on the left, and
each client represented by a bar or line).

But I can't make it so I can overlay The weeks or days of August for client
XYZ with the weeks or days of September for the same client, so I can see if
we are on pace with last month.

Which fields should I use for the Category, Series and Data (and Filter)?
I'm absoletly stumped, and I've been reduced to experimenting trying to
stumble across the solution.

Thanks.
 
Top