I've fairly new into SharePoint, so excuse any ignorance, but I recently started looking at SharePoint 2013 rather to see what it has on top of SharePoint 2010.
I signed up for a BUILD account so I now have a SharePoint 2013 developer site mydomain.sharepoint.com. I've created an internal list and then I wanted to add a graph to a page. I can't seem to however get this working in SharePoint 2013. With the removal of the Chart web part I'm supposed to be using Excel services.
So I had to create a local Spreadsheet thats bound to my list in the cloud, add a chart then upload that to my sharepoint site. I added a webpart to show the excel contents and I have my chart. The problem is, if I update the list the process to get the chart to update seems to be:
- Open the Excel file in SharePoint 2013 within my local Excel instance.
- Refresh the Data Connections
- Save the spreadsheet back to SharePoint 2013.
- Refresh the page
This doesn't really feel like a nice solution to bind a chart to a list properly! If I open the Excel spreadsheet using the Excel web app it suggests that the SharePoint list isn't supported in the browser mode. I'm assuming that this is why it neither updates automatically, nor when I open the spreadsheet in office 365.
I'm sure there must be a better way to do this though, does anyone know what it is?