| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| subtotalling with summary values above | Excel Discussion (Misc queries) | |||
| sorting detail rows - summary row in an outline | Excel Discussion (Misc queries) | |||
Linear Mode
