| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show/hide details in pivot chart
Client is using Excel 03/WinXP. She would like her users to be able to click
on a series in the chart and then have button to Show Detail. I recorded a macro with these results: ActiveChart.SeriesCollection(2).Select ActiveChart.PivotLayout.PivotTable.PivotFields("Da ys At This Workflow Step"). _ PivotItems("104").Showdetail = True The code is for the specific series that was selected when the Show Detail was selected. Can this be modified to be the the "Active Series"? I looked a the different options but was unable to see anything - but then again, I'm not very good at the VBA stuff! Thanks for your help!!! -- maryj |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide/Show details in an Outline Group | Excel Discussion (Misc queries) | |||
| Hide "Show details" when right click on data field in Pivot Table | Excel Discussion (Misc queries) | |||
| How can I show/hide plots in a chart? | Charts and Charting in Excel | |||
| SUBTOTAL'S SHOW AND HIDE DETAILS BUTTON MISSING | Excel Discussion (Misc queries) | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
Linear Mode
