SharePoint Chart Web Part

SharePoint Chart Web Part enables your users to build Charts based upon SharePoint Content, Microsoft SQL Databases, Excel Workbooks, OData, BCS and more.

Core Features


harePoint Chart Web Part offers a simple to configure 3D or 2D dynamic chart which can be based on a variety of data sources. Data sources include BCS Entities, SharePoint Lists, Excel Workbooks, SQL Databases and more. The Lightning Conductor can also act as a data source to SharePoint Chart which allows for aggregated SharePoint content to be displayed in Chart format.

Build Dynamic SharePoint Charts

Lightning Tools SharePoint Chart Web Part provides powerful single series, or multiple series Charts within SharePoint sites to reflect your line of business data. Every element of the chart can be configured from fonts, to line colours and all without code.

Multiple Data Sources

Charts can be quickly configured against multiple data sources include Business Connectivity Services Entities, SharePoint Lists, Aggregated SharePoint lists, SQL Databases, OData, Excel Workbooks + more.

Drill Down Charting for SharePoint

Multi-level drilldowns enable to you drill into charts to show more detail in a dynamic way. Drill downs can be configured easily within the Chart configuration wizard and allows you to drill down based on different types of values including Date categories.

Drill Down and Interactive Charts

Drill down into the charts to show more charting or data that the chart is based upon. Charts are configured in minutes and simple enough to be configured by SharePoint users.

The SharePoint Chart Web Part can be configured in just a few minutes to show charts based on Business Connectivity Services, Microsoft SQL, Oracle, Microsoft Excel Workbooks and SharePoint Lists. Below are two examples of dashboards that were configured without any code or the use of PerformancePoint. The web part is simply inserted on the page, and configured by the SharePoint Information Worker. Using BCS Meta Man, The Data Viewer Web Part and the Chart Web Part, your dashboards based upon Business Connectivity Services can be configured easily.



Build 3D Or 2D SharePoint Charts

The SharePoint Chart web part is an easy to configure web part that enables you to build charts on SharePoint content, Business Connectivity Services data, Microsoft SQL, Oracle or Microsoft Excel. The charts can be built in less than 15 minutes enabling Business Intelligent dashboards to be created in no time at all.

Interactive Pie Charts, Spin, Slice

There is a large selection of chart types to choose from including 2D or 3D bar charts, line charts, Pie charts and more. Users can configure data formatting, filters, grouping and aggregate functions using the easy to use step by step wizard.

Although you can preview the chart within the configuration wizard, you can also easily change your mind and just select a different chart type to represent your data if you are unhappy with the look and feel.

Your chart and its data can also be exported so that it can be used in other office applications such as Microsoft Excel.

Single Or Multiple Series Charts

As well as the chart type, users can customize the series, chart and axis titles, data display settings, chart appearance such as colours and formatting, trend lines and data formatting. The mult-tabbed interface makes configuring very powerful, but also straight forward and simple to use.

Multiple Data Sources Including BCS, SharePoint Lists, Oracle, SQL, Excel

The SharePoint Chart web part can be configured to connect to data within SharePoint Lists which includes cross site collection lists allowing you to display data such as a Tax list even from a site in another site collection. This complements the Lightning Conductor Web Part and the Data Viewer Web Part from Lightning Tools that can display data within a grid from across multiple site collections or also rollup data from multiple site collections. Meta Man can be used to create external content types for Business Connectivity Services. Once the External Content Type is created, as well as building SharePoint External Lists, you could build dashboard based upon BCS using the Data Viewer and Chart web parts. Finally, if you do not use BCS, it is possible to create connections directly to Microsoft SQL and Oracle. Excel Services dashboards can also be made more powerful by using the Chart web part to build extensive charts based on an Excel workbook.

The SharePoint Chart web part is offered in association with Collabion who are part of the FusionCharts company. Lightning Tools is an official reseller of the Collabion Charts product.