Develop a page with multiple Filter, Drill down report functionality, Display Chart, Download link of displayed report using Excel Service

Develop a page with multiple Filter, Drill down report functionality, Display Chart, Download link of displayed report using Excel Service - SharePoint 2010

Hi,

My requirement is as given below,

I need to develop a page with Filters + Chart + display excel data + drill down report + Download link. Need to get data from Excel file which uploaded in Shared Documents library.

I had searched in msdn and Google as such I got some info. Says like chart cannot be connected with filter web part!!

https://social.msdn.microsoft.com/Forums/office/en-US/e135d8ac-6d86-4b3e-ad27-0f91a54956c3/how-to-filter-data-based-on-the-list-columns-using-chart-webpart?forum=sharepointgeneralprevious

I can use Excel Web Access web part to display the Excel date and Chart web part to display chart with excel data. How to use Filter web part and drill down report with excel data? How to connect each of them?

I need to achieve this only with OOB available web parts and excel should not be imported to any custom list to achieve this scenario.

May 27th, 2015 2:10am

This topic is archived. No further replies will be accepted.