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.
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.
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.
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.
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.