I need guidance as I step into the dark land of the Evil Empire.

[johno]

I need some help with Microsoft Excel.

I'm trying to get trend report generated.

I have a excel spreadsheet that has 17 months of *daily* data in a simple table:

2003-11-14 50000
2003-11-15 55230
2003-11-16 62000
...
2005-03-19 70000
2005-03-20 71855
2005-03-21 71200

I can chart it easily enough, but I get a very wiggly graph and I'm more interested in seeing the weekly or monthly totals.

Short of creating the weekly/monthly sub-totals, is there an easy way to create sums or charts, with data subtotaled based on date?

Comments

well, I know a place you could ask...

[nagasvoice.livejournal.com]

I get email reports from a place called Woody's Watch, who seemt o know what they are about on various OFfice topics. (It's particularly amusing to read their rants about the security holes in IE, for instance.)
Many moons ago, I posted some questions and got fairly quick responses.
Woody's Lounge has different forums for various parts of Office in general, including one for Excel in particular. This is the Excel forum where you could post your question. Don't know if now you have to join the thing first, sorry.
http://www.wopr.com/cgi-bin/w3t/postlist.pl?Cat=&Board=xl