How to use SharePoint 2010 Chart Web part to display SharePoint list data in various chart type such as pie, bar, area etc

In this post, I will show how to use SharePoint 2010 chart web part to display SharePoint list data in various chart type such as pie, bar, area etc.

Step 1: Create a SharePoint list with two columns say “Country Name” and “Company revenue” with some data as shown below

Step 2: Chart web part is part of SharePoint Server 2010 enterprise edition. Therefore we must activate “SharePoint Server Enterprise site collection feature” and “SharePoint Server enterprise site features”.

After activation of these features make the Chart web part available in the business data type in add a web part gallery.

Step 3: Navigate to site page where you want to add web part and add a webpart from webpart gallery.

After addition of Chart web part, we will see two links “Data & Appearance” and “Advanced Properties” as shown below

After clicking on “Data & Appearance” link will launch a wizard to select a data source. Following data source can be used

In our case we will select “ Connect to a list” and click “Next” and then the source list. Finally we will reach to final page of wizard where we will specify x and y axes. Click “Finish”.

We can view result in various chart type as below below