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.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
no subject
Date: 2005-03-23 08:27 am (UTC)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.