Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Chart and EnableItemSelection
Hi,
I am using an Excel XP Pivot Table and associated Pivot Chart (connected to an OLAP datasource) I am also using PivotTable.EnableItemSelection=False to restrict users from directly selecting from a dimension in the pivot table. This selection is reflected in the pivot chart by the dropdown arrow being removed from the said dimension, but I am still able to click on the Pivot Chart dimension and select from the pop up selection menu that appears. I need the dimension on the pivot table, and I would like to retain the buttons on the pivot chart (i.e. objChart.HasPivotFields = True) I just want to stop selection from this dimension from either the pivot table or the pivot chart. Can it be done? Thanks in advance Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicating Pivot Chart / Changing Pivot Chart data range | Excel Discussion (Misc queries) | |||
How to create chart from Pivot table but not Pivot chart? | Charts and Charting in Excel | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) |