Create ChartView for your List

SharePoint gives different types of views as per your list type. When you try to create view you have 5 options.

  1. Standard View
  2. Datasheet View
  3. Calendar View
  4. Gantt View
  5. Access View

Well you can also create Chart view for custom lists.

Let’s say we have one custom list with fields Title,IsDeliverable, and Location

Create a new view from any of the standard view(e.g. All Items), and just save it with new name , say “Chart View”

Now open chart view page in SharePoint designer, and search for the “ListViewWebPart”, see the ListViewXml portion.

<ListViewXml xmlns=http://schemas.microsoft.com/WebPart/v2/ListView&#8221;><View Name=“{D939D853-A9C3-4AC7-ACDA-56E3F5F8DB5A}”
Type=“HTML”

You will see one parameter “Type” with value = “HTML”

Just change it to “CHART” and save the page.

And your view will be converted from standard list view to fantastic chart view (like survey lists). Here remember to remove columns like “Title” where it’s a chance to have multiple values. Try to have only columns with data types like Choice, Yes/No, Number, Lookup

SharePoint Creates this views as per its types.

For some types you need to apply appropriate changes in ListViewXML to render the view perfectly. You can take the sample of it from list where it by default appears.

Following are the possible types you can give

Type View Name By default appears in
HTML Standard View All lists
Subject View Discussion
Threaded View Discussion
Flat View Discussion
GANTT Gantt View Tasks, Project Tasks
GRID Datasheet View All Lists
CALENDAR Calendar View Calendar
CHART Graphical Summary Survey
AccessView

Pls. leave your feedback if you found this post useful.

Advertisements

7 Comments

  1. Kuldeep Singh said,

    May 25, 2008 at 9:31 AM

    Mind blowing!!!!

    Its the same for what i was looking.

    Just tell me how can we specify the type of Chart. like pie chart, bar chart etc.

    Kuldeep Kadyan

  2. Hector said,

    June 13, 2008 at 1:51 AM

    Excelent!!! Great Tip!

  3. Will said,

    September 29, 2008 at 11:42 PM

    How do you remove the columns (fields) from displaying in your chart?

  4. Dima said,

    November 17, 2008 at 8:54 AM

    Same problem: we have survey, which contains a First Name and Second Name fields, beside questions. So, how can i hide FN and SN from chart view?
    😦
    I’ve already broken my mind in searching solution….

  5. Diogo Kollross said,

    July 17, 2009 at 2:45 PM

    Excelent!!! Great Tip! (2)

  6. rahul said,

    April 9, 2011 at 5:54 PM

    Hey great artical,
    I want to change type of chart..So how can I ?

  7. SRINI said,

    July 26, 2012 at 12:22 AM

    If we want to change it to pie chart? how it can be done?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: