If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|