Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Web Service - Multiple Pivot Charts - How to Have One commonFilter
Excel Web Service - Multiple Pivot Charts - How to Have One common
Filter Hi, I have an Excel2007 dashboard, which contains more than 5 pivot charts. Its a testing dashboard, which has got several defect metrics based on same data source. I am publishing these pivot charts to Sharepoint using excel web service. Currently I need to fiter all pivots one by one to see the charts for different parameter. something like (if I need to select the defects for different releases, i select them one by one in all pivots). I know, i can create a simple macro to trigger updates to all pivots. But the problem I am facing is - After I publish the pivot charts to Sharepoint. Macros will disabled (not supported in Shoarepoint 2007). So, please suggest me if there is any workaround possible to create a common filter on Sharepoint that will refresh all the pivots. Thanks, Avinash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple charts from a single pivot table | Charts and Charting in Excel | |||
Multiple Charts-Same Data Pivot | Charts and Charting in Excel | |||
How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
creating pivot charts from multiple pages | Excel Programming | |||
multiple pivot charts | Excel Programming |