One of the lacking feature in MOSS 2007 was not having
functionality to draw chart based on various sources even not with list.
Now with SharePoint 2010, we can draw chart not only from
lists but also from various sources like SQL server or excel for example.
In this post, I am going to demonstrate you a way to draw
chart using list by using SharePoint Chart web part.
I have a list in my site with following data. Data is
only shown for an example. Real scenario can be different based on business
need.
Find and add chart web part to a page.
The moment you add chart web part, you get something like
this
Click on data and appearances. It gives you two options,
connect with the data and customize your chart.
Click on connect chart to data. You get an option to get
the data from list, BDC, excel or another web part. Select list.
Advantage is you not only can select list from the same
site but from the entire site collection.
You get a screen showing data from the list. You can also
set the filter option as mentioned in a screen shot. It allows you to return
only limited number of data from the list if you wish to. You can also preview
it. I am leaving it empty.
Now you are on a screen where you can actually bind the
data with the chart web part. Here we can select type of chart, columns for x
and y axes, labels for the chart, Grouping option etc.
Click on finish. Bingo!! We now have a chart on our page.
But still it does not give proper picture. So let us go
ahead and now click on advanced properties.
You can set various properties here. You can change back
ground color, gradient style, hatch style, skin style, change the palette.
You can check out different options from left hand side
which also allows you to show legends, 2D or 3D chart.
You can also show labels of data.
If you would like to have connection for the chart web
part, you can also use content menu and then configuring data section.
Now if you go back to data and appearances and click on
customize the chart, you get an option to select a chart type from range of
different chart types.
And then you can follow the same procedure to configure
the chart the way you want.
The best part is the chart web part is dynamic, means any
changes to the data or any addition to the data gets reflected automatically
Let’s change our existing list data and add one more list
item.
I changed February data from 1670 to 2500 and added one
more list item for September month.
I hope you like this post. Keep exploring chart web part
which is definitely a welcome addition to SharePoint 2010.
1 comment:
Your post is so interesting. and it is more useful and helpful for me. Thanks for share this valuable post.
Post a Comment