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

[elizabear.livejournal.com]

Gah, I used to be an Excel power user, doing graphed reports every month as part of my job. But that was 5 years ago, well before the baby ate my brain.

I've just scanned O'Reilly's EXCEL HACKS book - there's no good way in there to do what you want.

I'd go with charting the sub-totals - it doesn't take long to input a range for a sum function.