Can we create a pie chart using excel reporting service. I have a excel file (.xlsx) on my SharePoint document library. I want to use excel data and create a pie chart but don’t want to create this pie chart in excel.
I have created a pie chart in excel and show this chart on my site using excel web access web part but my client don’t want to use this approach. Please suggest any different way to create pie chart from excel and display on web site.
Is it possible to pick the data from a excel file (.xlsx), generate report and display it on SharePoint site.
If it is not possible then please suggest the right way to achieve the same.Â
Hi Anshul,
If your client don’t want to use Excel webAccess webPart I would suggest you to Create a custom service which will read the data from your excel file and return in JSON format ,pls follow below URL for more info.
http://codepedia.info/2015/04/chartjs-asp-net-create-pie-chart-with-database-calling-jquery-ajax-c/
