BillyS - 1:33 am on May 16, 2009 (gmt 0)
Here's another approach I use because my site has a weekly pattern (weekends drop off). What I do is chart a rolling 7 day average. You just use =average(B2:B8), then copy down the formula (using a double click in the corner of the cell <-- another tip). This is a smoothing technique you can use.