In SharePoint Server 2010 we have a interesting web part know as Chart Web part
Chart Web Part
----------------Right now in Beta Bits you can find this web part under "Miscellaneous" section. This web part can be used to build chart from the data that is present in Sharepoint List, Excel Sheet (that is published using Excel Services), data from SQL Server and also from another web part that provides data. Its very easy to configure. For a chart using Sharepoint List follow the link Chart using Sharepoint List . Also the same can be achieved using data present in Excel. Steps to achive it.
1.Publish Excel using Excel Services to a document library (Excel Services remains same with regards to MOSS expect REST API).
2.Add the Chart Web Part.
3.Click on Data Appearance.
4.Put the Excel Workbook Path.
5.Range Name (very important)
6.Once you click next the data present in the excel sheet will be displayed. You can do the formatting as you need.
7.Bind data with the chart and you are done.
1.Publish Excel using Excel Services to a document library (Excel Services remains same with regards to MOSS expect REST API).
2.Add the Chart Web Part.
3.Click on Data Appearance.
4.Put the Excel Workbook Path.
5.Range Name (very important)
6.Once you click next the data present in the excel sheet will be displayed. You can do the formatting as you need.
7.Bind data with the chart and you are done.
No comments:
Post a Comment