Show one total summary but have drill down to detail
 

I am working a spreadsheet that totals for certain categories. Frequently it
is necessary to see the detail that made up that figure. Right now I am using
comments but this laborious. I'm not sure if pivot tables are what I need or
not.
Basically I have a total and would like to mouse over or something and go to
a different chart/page to see the breakdown.

Hi
use a pivot table. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2...ble/trackback/

--
Regards
Frank Kabel
Frankfurt, Germany
"Kharpo7" schrieb im Newsbeitrag
...
I am working a spreadsheet that totals for certain categories. Frequently
it
is necessary to see the detail that made up that figure. Right now I am
using
comments but this laborious. I'm not sure if pivot tables are what I need
or
not.
Basically I have a total and would like to mouse over or something and go
to
a different chart/page to see the breakdown.