If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart daily data and add a trend line for each week
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 |
Thread Tools | |
Display Modes | |
|
|