Chart web part is a new feature in SharePoint
2010 which is used to create static and dynamic charts. In this article we will
be seeing how to create an out-of-box chart web part in SharePoint 2010.
Add the Chart web part:
- Go to the SharePoint site.
- Go to Site Actions = Edit the Page.
- In the ribbon interface, go to Editing
Tools = Insert = Web Part.
- In the Categories, select Business Data =
Chart Web Part.
- Click on Add.
- A sample dummy chart will be displayed as
shown in the following
We will be seeing how to create a chart by connecting to the following data
- Connect to a list.
- Connect to another web part.
- Connect to Excel Services.
Connect to a SharePoint List:
- Click on Data & Appearance.
- You could see the following options as
shown in the following.
- Click on "Connect Chart to Data".
- In the Data Connection Wizard select
"Connect to a list" option.
- Click on Next.
- In the List Connection, select the site
and the list.
- Click on Next.
- You can view all the data and you can
configure the filter the data as shown in the following.
- Click on Next.
- In the "Bind Chart to Data" section, you
can choose the X field and Y field and lot of other configurations can be
made in this section.
- Click on Finish.
- You could be able to see the chart
displaying the SharePoint list items as shown in the following
Customize the chart:
- Click on Data & Appearance.
- Click on "Customize your chart".
- Select the Chart type and click on Next.
- You can change the chart appearance as
shown in the following.
- Click on Next.
- Chart Element Properties.
- Click on Finish.
- My chart looks like the following
- Advanced Properties:
Connect to Excel Services:
- In this section, we will be seeing how to
connect to the excel services.
- I have created a named range in the excel
workbook which contains the following information.
- I have uploaded the excel workbook to the
"Shared Documents".
- In the Chart web part that we have
created, go to "Data & Appearance" = Connect Chart to data".
- Select "Connect to Excel Services" option.
- Enter the Excel workbook path
http://serverName:1111/hr/MP3/Shared%20Documents/Rank.xlsx and enter the
range.
- You could see the values retrieved from
Excel workbook.
- Chart connected to excel services:
Similarly you could connect to the another web
part and display the chart with those data.
Raghu TejPosted May 17, 2013, 5:54 AM
I have installed Business Data webparts, but in the list of business data i dont find Chart webpart. How can i install or get the chart webpart in the business data webparts.
Rahul VartakPosted Feb 7, 2013, 2:42 AM
Hey Jignesh, Did you figure a way to change colors dynamically based on value ?
Jignesh JoshiPosted Jan 30, 2013, 9:42 AM
How to take the print out of the chart?? Data & Appearance and Advance property option should not appear in printout
Jignesh JoshiPosted Dec 19, 2012, 9:50 AM
How to change the bar color in single series on specific condition? I have chart web part of ratings given by users so i want that if rating is less than or equal to 2 than that particular bar color should be Red.
Jignesh JoshiPosted Dec 19, 2012, 9:50 AM
How to change the bar color in single series on specific condition? I have chart web part of ratings given by users so i want that if rating is less than or equal to 2 than that particular bar color should be Red.
Jignesh JoshiPosted Dec 19, 2012, 9:50 AM
How to change the bar color in single series on specific condition? I have chart web part of ratings given by users so i want that if rating is less than or equal to 2 than that particular bar color should be Red.
Fuji OgawaPosted Jul 3, 2011, 9:30 PM
Hello Vijai, Thank you for this detailed article. I can grasp overall functionalities of Chart Web Part very easily. By the way, I have one question. We have a custom list which consist of one column named "Your choice" with choices "A", "B" and "C". And many people access to that list and select the one of those choices like polling. I would like to show the results of that polling with the bar chart by using Chart Web Part (such as 10 items for "A", 5 items for "B" and 2 items for "C"). Because of your detailed explanation, now I know how to add a web part and connect to that list but the graph can not show the result appropriately. I would like to show the number of items in "Y-field" and the choices in "X-field" but there is not "Your choice" column in the drop-down box of "Y-field" so I cannot set it as "Y-field". Perhaps Chart Web Part cannot count the number of items? I apologize for my poor English in advance. Could you please help me? Fuji
Mahesh ChandPosted Jun 25, 2011, 1:03 PM
Good work!