1

I am in charge of a SharePoint site for a team of writers, which we use to keep track of our topics (we have an extensive list of topics with their workflow status, version of the product, feature, etc).

I'd like to create some charts using the information from this list that give the writers an overview of their topics and how far they are in the writing process. For example, number of topics by status, number of topics by product/category/feature, number of topics by writer, and so on.

The charts web part used to solve this, but I understand that it has been removed. I am working in the Office 365 version of SharePoint and I'm not a developer. Does anyone have any suggestions?

1

One option could be to use Excel charts/graph and publish it on SharePoint Online with Excel Services. Check the links below:

http://www.dummies.com/how-to/content/how-to-use-sharepoint-online-excel-services.html

https://support.office.com/en-us/article/BI-capabilities-in-Excel-and-Office-365-26c0548e-124c-4fd3-aab3-5f64568cb743

  • I've looked into this, but as far as I can make out, this would mean that I would have to keep the data in Excel up to date and not use the data from SharePoint. Is that correct? The charts have to be dynamically updated by the information from the SharePoint list or the won't be useful. – Kristine Feb 9 '16 at 7:42
  • Assuming the data is maintained in a SharePoint List, you can export the list into Excel which will have the data connection with SharePoint List. So if you add data on SharePoint List and refresh in Excel you will have updated data. See this rippleeffect.com/2011/07/permanantly-link-data or If you a developer you can also look at this: sites.se/2013/12/sharepoint-online-charts-office-365, – SharePointer Feb 9 '16 at 9:25
  • Hmm - we don't work in Excel and this would mean having to constantly manually go in and update the Excel spreadsheet. What I'm looking for is charts that reflect the list in real time. Unless I'm missing something, this doesn't sound like the workaround that I was hoping for. – Kristine Feb 9 '16 at 13:31
  • Then I think the only option is to custom built it something along the lines I have suggested in my earlier comment or use third party tools. – SharePointer Feb 9 '16 at 14:42
  • Thanks - that's what I thought. It's nice to have that confirmed. Do you have any idea of a third-party tool that's reliable? – Kristine Feb 10 '16 at 8:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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