Smarter Way to Build SharePoint Charts From Lists, Libraries, or External Data Sources

Building a SharePoint chart is an intelligent way to visualize data from various sources, like SP lists, libraries, and external sources. Instead of staring at an ocean of information, decision makers can quickly make sense of prevailing trends, brainstorm on ways to improve efficiency and profits without compromising on quality, and a whole lot more. Not surprisingly, this makes data visualization an invaluable tool for decision makers in the boardroom.

SharePoint charts can be built from various data sources, including SharePoint lists, Excel worksheets, SQL Server/Oracle databases, and even from many other external data sources via BDC or ODBC connectivity. The following are a few ways that work better and faster than others.

Bringing back chart web part-SP list combo

Anyone working with SharePoint has made use of lists at some point of time, in order to easily collate information. SharePoint 2013 onwards, users have to connect these lists to SharePoint’s Excel services web part to create charts, as the native chart web part has been removed from SharePoint. This can rob the user of a lot of options, as well as varieties of charts, which were present in earlier versions of SharePoint.

However, all is not lost. If a user exports a project that was using chart web part in SP 2010, then the web part will also be exported. Following this step, the user can make use of the discontinued web part without any problem.

Integrating SharePoint library with Excel

A Microsoft Excel workbook can be published directly to a SharePoint library. Once that is done, data from the workbook can be used to create charts and graphs, from a centralized data repository. If the user is working with SP 2013 or later versions, then this step might seem useless as far as creating charts is concerned, since charts will have to be created using Excel services anyway. However, if the chart web part has been exported from SP 2010 beforehand, or a third party tool is being used to create the charts, then this step can really speed up chart creation and simplify data management as well.

Using third party tools to create charts

A third party tool that does not require the user to write codes to create charts can save a lot of time for busy executives. Not only that, these tools often support a wide variety of data sources, allowing the user to choose a data source that he prefers to use – from SP lists to Excel workbooks, and even database files from popular RDBMS suites. Such tools can be used to create/modify charts on the fly, and even update them in real time as the user modifies data sources when necessary.

These are three of the ways to create SharePoint charts and graphs from different data sources, efficiently and quickly. Among these, while exporting the chart web part from SP 2010 can help users, making use of a third party tool is by far the most convenient way for creating charts and graphs in newer versions of SharePoint.