Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot report and Filter boxes
Hi again,
In 2003, if you created a pivot report or graph from a dataset, you had the option to drive the selections from the chart itself or the underlying pivot table. In 2007, it seems this can only be done through the pivot table headers. Is this true? If it is, it's annoying as for my report, I want the graph visible only. Is there a way o Lords of Excel? Best regards, Bony |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot report and Filter boxes
Please ignore this knee jerk question. I just found the PivotChart Filter
button on the ribbon. It's been a long year sigh ..... "Bony Pony" wrote: Hi again, In 2003, if you created a pivot report or graph from a dataset, you had the option to drive the selections from the chart itself or the underlying pivot table. In 2007, it seems this can only be done through the pivot table headers. Is this true? If it is, it's annoying as for my report, I want the graph visible only. Is there a way o Lords of Excel? Best regards, Bony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Table - Sort Report Filter Values | Excel Discussion (Misc queries) | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
how do i elmininate old data from Report filter on pivot table? | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot table's Report filter fields value sorting | New Users to Excel | |||
Pivot table report filter problem | Excel Discussion (Misc queries) |