Hello you smart beautiful and helpful bunch! Don't you just want to spend your valuable time helping a pour smuck with his Chart? I know you do, so here it goes.

Say I have a table that has a record for everyday of the month, and each record has a field with a numerical value for how much I exercised that day. In another related table and layout I have a line chart that graphs the days along X and the exercise value along Y.

I can get that far, where I run into trouble is when I want to graph more then one month's timeline in the same chart, one on top of the other. When ever I try it just puts the months one after the other. Depending on how I sort it the chart along X is going from Day 1 to Day 30 for the first month and then 1 to 30 for the second month. Or if I sort it differently it gos 1,1,2,2,3,3 etc.

Is there some way to over lap records that share the same day of the month so I can get each month on top of eachother?

Let me know! Thanks.

Like this?

Compare2Months.zip

Like this?

Nice! Thanks!