From: clcnewtoaccess on
Excel 2003
Is there a way to create a chart using daily data and create a trend line
for each week. The data does not have an Saturday's or Sunday's.

My data looks like this.

Date Output Input
2/15/2010 229 215
2/16/2010 441 153
2/17/2010 205 43
2/18/2010 283 138
2/19/2010 609 121
2/22/2010 272 136
2/23/2010 373 16
2/24/2010 193 176
2/25/2010 339 358
2/26/2010 533 238
3/1/2010 374 252
3/2/2010 244 269
3/3/2010 306 216
3/4/2010 297 229
3/5/2010 538 202
3/8/2010 235 373
3/9/2010 446 410
3/10/2010 385 335
3/11/2010 457 89
3/12/2010 462 71
3/15/2010 303 420
3/16/2010 575 139
3/17/2010 323 452
3/18/2010 414 129
3/19/2010 621 436

Thanks,

--
clcnewtoaccess