Wednesday, December 28, 2011

How to create Chart in SharePoint 2010

Sharepoint 2010 make creating Chart become easier than ever before. With Chart Web Part we can creating chart quickly without coding. I this post, I will show you how to create a Chart Web Part in Sharepoint 2010.

Step 1: Create a new custom list.
You need to create a new custom list. I use the "Employee" list with 5 colume: Title, Birhtday, Male, Position and Salary.

Step 2: Create new Page
Create a new SharePoint page by clicking on the Site Action -> New Page, then name the page "Salary Chart".

Step 3: Add the Chart Web Part to the page
From the "Editing Tool" ribbon group, select Insert->Web Parts. The select "Chart Web Part" under "Business Data" Categories and press the Add button. Finally click "Save & Close" to save the page.


Step 4: Connect Chart to SharePoint List
Now you need to bind the chart to the data source. In the Chart Web Part, click on Data & Appearance. On the next page, click on Connect Chart to Data.


 Select "Connect to a List" and click "Next" as show in the figure bellow:


 On the next page, select Employee list from the dropdownlist and click Next.


Click Next.

Step 5: Bind Chart to data
From "Y Field" drop down select "Salary", from "X Field" drop down select "Title". These 2 column are the fields from Employee list. Click "Finish", as show in figure below


 The chart is now show on the Salary Chart Page as shown in the figure bellow:

 Step 6: Customize the Chart
On the Chart Web Part, select Data&Appearance. On the next page, select Customize Your Chart. The the Select Chart Type, select "Custome" on the "Chart Type Categories" panel and select Column under the "3D Chart Types" on the "Chart Template" panel, then click Next. (You can select any chart type you like)

On the next page, I customize the appearance them of the chart and finally click Finish.


And the bellow figure is the final appearance




 Hope this helps!!!

1 comments:

Đỗ Quốc Hùng said...

Thanks for your post. but ii would like ask you to create filter fromdate and todateto filter data. can you help me. my skype doquochung

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Affiliate Network Reviews