Friday, June 6, 2014

Working with Chart Web Part in SharePoint

In this post we will discuss how to populate a chart web part from a SharePoint list. Here I am using chart web part in SharePoint 2013. Though Microsoft removed chart web part, you can check this work around to make chart web part available in SharePoint 2013.

Also you can check out:

- How to get Absolute URL of List using SharePoint object model?

- Backup and Restore Site Collections in SharePoint 2010 using PowerShell

- Vertical flyout menus in SharePoint 2010

Here I have a SharePoint list name as "Course" which has 5 columns and the data are like below:

chart web part sharepoint 2010

Here I want to show a chart (bar) and want to see in Sharepoint 2013 how many trained, novice, intermediate and expert people. Similarly for SharePoint 2010, Asp.net and C#.Net skills.

For this first add a chart web part to the page (Edit Page -> INSERT -> Web Part). Once you will put the chart it will appear like below. Save the page.


chart web part sharepoint 2013


After that click on Data & Appearance. Then select Connect Chart To Data as shown in the fig below:

chart web part sharepoint 2016

In the next step select "Connect to a List" in the Choose a Data Source section. Then click on Next.

chart web part sharepoint online

In the next step select the site and the list in the drop down.

In the next step it will show you the list and the data. Click Next.

The 4th Step Bind Chart to Data is an important step. Follow below instruction. Here

In the Series expand (click on +) Series Properties. Enter name, here I am putting based on my column names. It should be like below:

Series Name: Trained
Series Type: StackedColumn (From the drop down select the column).
Y Field: Trained (Select Trained Column from drop down)
X Field: Title (Remember this will be same for all series)

So it will appear like below:


Then click on the + icon near series like below:


Here also fill the series details like below:

Series Name: Novice
Series Type: StackedColumn (From the drop down select the column).
Y Field: Novice (Select Novice Column from drop down)
X Field: Title (Remember this will be same for all series).

So it will be appear like below:


Add all based on the columns. Here I added 4 for each columns (Trained, Novice, Intermediate and Expert).

Then click on Finish.

Now your chat will appear like below:


If you want to customize a bit like you want to show the count as well as a image in the top right corner follow below steps.

Here click on Data & Appearance, then click on Customize your chat.

Here select Stacked Column and click Next as shown in the fig below:

Chart Web Part in SharePoint 2013

You can set the width and Height of the chart web part. then click on Next.

The next step is very important, if you want to Show Legend then you chose Show Legend.

Chart Web Part in SharePoint 2010

You can go to the Axis and Gridlines tab and if you do not want the Major Grid lines then you can deselect "Show Major Grid Lines" for both X and Y axis.

If you want to show the Labels then you can select the Label and click on Finish.

Chart Web Part in SharePoint 2016

Finally your chart will appear like below:

Chart Web Part in SharePoint online

7 comments:

  1. Thanks for the nice post

    Packers and Movers Bangalore Will Ensure Tension-Free Move

    Ready to move? Request free quotes today!

    Packers and Movers Bangalore @ http://www.shiftingguide.in/packers-and-movers-bangalore.html

    ReplyDelete
  2. There's a lot of interesting info here! I'm very grateful for the post! movers and packers ahmedabad is here to make your life simpler.
    http://packersmoversahmedabad.co.in/
    http://packersmoversahmedabad.co.in/packers-and-movers-surat-gujarat

    ReplyDelete
  3. This is useful content. really apreciate it! visit here.

    This research is practically done by you and gives good ideas. visit here some useful content here. i love this website. your site is good and your work is very good for social work.. keep work.

    http://packersmoverschennai.in/

    ReplyDelete
  4. We Provide Best Packers And Movers Jaipur List for Get Free Best Quotes, Compare Charges,
    Save Mone And Time,Household Shifting Services @ JaipurPackersandMovers.in
    Packers And Movers Jaipur

    ReplyDelete
  5. Thank you for the informative post. It was thoroughly helpful to me. Keep posting more such articles and enlighten us.
    SharePoint jobs in Hyderabad
    SharePoint jobs in Chennai

    ReplyDelete
  6. This blog is so nice to me. I will continue to come here again and again. Visit my link as well. Good luck
    obat aborsi
    cara menggugurkan kandungan
    cara menggugurkan kandungan

    ReplyDelete
  7. a pride for me to be able to discuss on a quality website because I just learned to make an article on
    cara menggugurkan kandungan

    ReplyDelete