Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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:

  1. Open the Excel file in SharePoint 2013 within my local Excel instance.
  2. Refresh the Data Connections
  3. Save the spreadsheet back to SharePoint 2013.
  4. 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?

share|improve this question
add comment

4 Answers

Chart WebPart along with other functionalities have been removed from Excel Services because you now can do that same task from inside Excel Web App itself.

If you're using Office 365 Developer Site, you can Add a new app, and choose "Napa" from the store, once Napa is added to your developer site, you can choose it to create a new project, and choose Content App For Excel, you can use the functionality that you already know in excel to build your charts.

Hope this would help you.

share|improve this answer
add comment

I agree that using Excel is not a good option when you need real time.

The following blog post explains how to import the Chart Web Part to SharePoint 2013, however it might not be supported and might not work with future package updates: http://monkeyblog.highmonkey.com/default/August-2013/Chart-Web-Part-and-SharePoint-2013.aspx

My personal choice is to use client side charts. I have a couple examples on my blog:

share|improve this answer
add comment

Look at http://www.aasoftech.com/SitePages/How%20to%20create%20a%20Chart%20from%20SharePoint%20List.aspx and also video at https://www.youtube.com/watch?v=XM37pNFMCUg .

This tool allows you to create Google chart using client object model. The code is ready to use. You can download the code from the site.

share|improve this answer
    
While this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference. –  Kit Menke Sep 3 '13 at 16:57
add comment

We have been trying to chart a list in Sharepoint 365 online and the whole excel services caused some pain. One of our developers used chart.js and an app to render some live charts from a list.

http://www.simego.com/Blog/2013/09/Charts-and-Office-365-SharePoint-Online

share|improve this answer
    
We require relevant answers and disclosure of any affiliation with products or websites. Also, your answers are considered to be spam because all of your answers only contain links to your products. Please see sharepoint.stackexchange.com/help/behavior –  Kit Menke Sep 3 '13 at 16:54
    
Apologies, I put 'our developers'. I do work for Simego but we don't sell charts, we developed a solution for an internal dashboard. I was pointing at our blog about charting. I will disclose more clearly. –  David Evans Sep 20 '13 at 10:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.