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!
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.
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! 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.
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
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?
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
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.
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, 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
+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!