Parameter not appearing for selection in Report>Excel Chart Editor panel. RRS feed

  • Question

  • Parameter not appearing for selection in Report>Chart Editor.
    I have created a simple Excel Pie chart from a pivot table using a data connection library file source (to Analysis cube) published my Excel object to Excel Services in Sharepoint and placed it in a dashboard, and I can view the object in Preview - very nice..
    But then I wanted to link a filter to the Pie chart when I put it on a dashboard page. So I did the necessary stuff and when publishing to Excel services I used the special Parameter tab and added a parameter called YearGroup, which uses the excel name range YearGroup on the pivottable.

    I refreshed the Excel chart definition in Designer and viewed it and
    it looks fine, but the Parameter does not appear in the worksheet
    parameters list in the Editor tab- so I cannot select it when applying a filter.
    I expect the parameter to be listed under then Worksheet parameters
    when I look at the Chart Editor panel. - where is it?
    Saturday, January 12, 2008 12:09 AM