Peter Kalmstrom shows how to use Excel Services to add a graph to a page in SharePoint 2013 Enterprise. Please also refer to www.kalmstrom.com/Tips/SharePo...
I add the graph and everything but I can not filter the graph like you do starting at 5:03. When I hover over my graph it says excel chart or image if that makes any difference
I'm having difficulty presenting charts not on the main tab of the excel sheet. Is there any additional information that needs to be provided for charts/graphs on various tabs throughout the excel file?
Hi, I have followed these instructions, which are great by the way. However the charts i am displaying do not have the pivot choice options available, so cannot be changed whilst viewing these on the SharePoint site. We are running the 2010 version so this may be the reason but i am not entirely sure. can you advise please?
I am not 100% sure when the pivoting was introduced into the web version of Excel, but I do think it was later than the 2010 version. So upgrading is your best option, no doubt.
Ann Kotik In that case I would suggest making a navigation page and then allowing the user to dig deeper by going to a specific page with your second graph. Peter
hi Peter your vids are crazy in clearness! thanx. but i've a problem in show the graph. I made the same things you made it, but the chart isn't showing. in came a modal with this message: "Canno't open the working folder It's not possible to popen the working forlder caurse it's archived in a url not attendible. To create a right url contact the sys admin" sorry for the translation but i'm not english." I can't understand what to do cause the url is correct!
Thank you for this tutorial :) I did all as shown in this tutorial, but the graph wont show up for some reason. Only thing that is visible is the Excel web access link. When I click on it it opens the graph view. What could b e wrong?
Hello! Is there a way to add a graph based on a Pivot Table based on multiple consolidating ranges? At the moment, I'm getting errors saying "there are features that are not supported by Excel in the browser."
+captainJD777 I would have to look at your specific table to determine if that is possible or not. Contact at support@kalmstrom.com to get a quote for that work.
Hi Kamlstrom, everything works fine for me except that once all is done, I cannot click on the filter arrow. Looks disabled. Then if I refresh the graph (right click, refresh), the filter is suddenly enabled and works perfectly. Is there a reason why I dont have it enabled by default when opening the page for the first time?
Hello Peter is it possible to setup an approval flow for each resource at sharepoint calendar ? I need to create car reservation via calendar at Sharepoint, but some approvals are required 1- email to user (requester) 2- email to approval (manager) 3- email reporting that the request has been approved or rejected thanks Reinaldo Brasil
Yes, it is certainly possible. I have some videos about approvals and all of them can be used on a calendar list also. Please have a look at www.kalmstrom.com/Tips/SharePoint-Workflows/Approvals.htm and www.kalmstrom.com/Tips/SharePoint-Flows/Flow-Approvals.htm
+SAUL SM It does work with SharePoint lists also, but the data will NOT be automatically updated when data in your SharePoint list changes. You will have to either open the Excel file manually to update the external data or use a PowerShell script to do an automatic update for you. A demo on how to do that is forthcoming!
Hi Peter, I have a web part linked to a pivot table. I have introduced a slicer to my pivot table in order to let the user filtering on a defined criteria. Unfortunately, I did manage to get this slicer added to my chart in SahrePoint. By any chance, do you know how to get my slicer taken into account by the Web Part ? Thanks & Kind regards, Saliout76
Hi, i am subscribed with Microsoft online sharepoint online enterprise but the ribbon does not appear to me. Btw i am the admin and have the full rights.
Thank you for this tutorial. You said some things that helped a lot that I did not pick up on from other tutorials.
I add the graph and everything but I can not filter the graph like you do starting at 5:03. When I hover over my graph it says excel chart or image if that makes any difference
I'm having difficulty presenting charts not on the main tab of the excel sheet. Is there any additional information that needs to be provided for charts/graphs on various tabs throughout the excel file?
Awesome ... thanks !!
Most welcome!
super! thank you
Hi, I have followed these instructions, which are great by the way. However the charts i am displaying do not have the pivot choice options available, so cannot be changed whilst viewing these on the SharePoint site. We are running the 2010 version so this may be the reason but i am not entirely sure. can you advise please?
I am not 100% sure when the pivoting was introduced into the web version of Excel, but I do think it was later than the 2010 version. So upgrading is your best option, no doubt.
Thank you for the video, it worked for my Power Pivot charts.
Do you know how to display 2 graphs instead of 1?
Hi Ann, how about you simply add another graph to the same page?
Hello,
Several graphs would be too heavy, I have a ppt and power pivot feeds and it is already taking long time to refresh a page.
Ann Kotik In that case I would suggest making a navigation page and then allowing the user to dig deeper by going to a specific page with your second graph.
Peter
hi Peter your vids are crazy in clearness! thanx.
but i've a problem in show the graph. I made the same things you made it, but the chart isn't showing. in came a modal with this message: "Canno't open the working folder
It's not possible to popen the working forlder caurse it's archived in a url not attendible.
To create a right url contact the sys admin" sorry for the translation but i'm not english." I can't understand what to do cause the url is correct!
upd: my sys admin gave the right address. all right now. ;)
Thank you for this tutorial :) I did all as shown in this tutorial, but the graph wont show up for some reason. Only thing that is visible is the Excel web access link. When I click on it it opens the graph view. What could b e wrong?
No idea, sorry!
one question sir? is this chart dynamic ? when the list item changes will the graph change too? Thank you so much
Please refer to: kalmstrom.com/Tips/SharePoint-Online-Course/HelpDesk-Chart-Update-Overview.htm
Hello! Is there a way to add a graph based on a Pivot Table based on multiple consolidating ranges? At the moment, I'm getting errors saying "there are features that are not supported by Excel in the browser."
+captainJD777 I would have to look at your specific table to determine if that is possible or not. Contact at support@kalmstrom.com to get a quote for that work.
Hi Kamlstrom, everything works fine for me except that once all is done, I cannot click on the filter arrow. Looks disabled. Then if I refresh the graph (right click, refresh), the filter is suddenly enabled and works perfectly. Is there a reason why I dont have it enabled by default when opening the page for the first time?
+cg1609 Seems like something has changed and that feature is no longer supported by Microsoft at this time.
Hello Peter
is it possible to setup an approval flow for each resource at sharepoint calendar ?
I need to create car reservation via calendar at Sharepoint, but some approvals are required
1- email to user (requester)
2- email to approval (manager)
3- email reporting that the request has been approved or rejected
thanks
Reinaldo Brasil
Yes, it is certainly possible. I have some videos about approvals and all of them can be used on a calendar list also. Please have a look at www.kalmstrom.com/Tips/SharePoint-Workflows/Approvals.htm and www.kalmstrom.com/Tips/SharePoint-Flows/Flow-Approvals.htm
does this also work on Sharepoint Foundation? or do you need to have Enterprise for this function?
This is Enterprise only.
Hello, does it works with SharePoint list too?
Thanks
+SAUL SM It does work with SharePoint lists also, but the data will NOT be automatically updated when data in your SharePoint list changes. You will have to either open the Excel file manually to update the external data or use a PowerShell script to do an automatic update for you. A demo on how to do that is forthcoming!
Hi Peter,
I have a web part linked to a pivot table. I have introduced a slicer to my pivot table in order to let the user filtering on a defined criteria. Unfortunately, I did manage to get this slicer added to my chart in SahrePoint. By any chance, do you know how to get my slicer taken into account by the Web Part ?
Thanks & Kind regards,
Saliout76
Did you try showing the entire tab where you have both the pivot table and the slicer?
Indeed I wanted to do it but I have not found so far how to proceed.
When you save your Excel file, under the Save As Web Options you can can select what should be visible in web view.
I have not found the Web Options under the Save as. Maybe because I am using Excel 2010. Thanks anyway for the time you granted me.
Hi,
I use Excel 2013, but i dont have ANALYZE on the top, should i activate sth? how?
Thx,
Hi,
Most likely you are not in a Pivot Table. The ribbon Analyze tab only appears when you select a pivot table.
How should i get into pivot table then?
+Mahdi Heidari Click in the pivot table.
Thanks alot for ur help, it worked :))
+Mahdi Heidari I am glad to here that :-)
Thanks but you could have mentioned that you need an enterprise license earlier on
Hi, i am subscribed with Microsoft online sharepoint online enterprise but the ribbon does not appear to me. Btw i am the admin and have the full rights.
The ribbon only show on the classic User Interface. It will not show on the modern User Interface.