Blog do Enéas

In the company where I work we use Windows SharePoint Services 3.0 and recently felt the need to view certain information graphically.

Immediately I decided that I would do this manually, it would be very hardness. So I created, based on  EndUserSharepoint post, two webparts to generate dynamic charts from Google Charts API in grouped lists of Sharepoint.

Installation is very easy:

• Download files below

  Dynamic Bar Chart for Sharepoint (4,5 KiB, 29 hits)
You need to be a registered user to download this file.

  Dynamic Pie Chart for Sharepoint (4,5 KiB, 25 hits)
You need to be a registered user to download this file.

• Send files to your Web Part gallery
• In the grouped list you want to show the chart, edit the page and add the Web Part
• Enjoy!

If you don’t have permissions to access Web Part gallery, you can have dynamic charts too by directly inserting the source code:

• Download the DWP files
• Open it with a text editor, like Notepad or GEdit
• Copy the code between <![CDATA[ and ]]>
• In the grouped list you want to show the chart, edit the page and add a Content Editor Web Part (CEWP)
• Just enter in the Source Code editor mode and paste the code

Known bugs:

# 001 – The chart is generated considering only the current page. If your list has several pages, only the current page will have the data in the chart.
# 002 – Google Charts API has a limit of items to render the chart. I don’t know exactly how many because they can vary with the size of the generated url, but the problem occurs when there are dozens of groups on a single page.
# 003 – UTF8 encoded terms support

Features for future versions (your help is appreciated):

# 001 – More supported charts (use of all power from Google Charts API)
# 002 – Support for non-grouped lists (based on rows and columns)
# 003 – Displaying charts on other pages (to generate something like a dashboard)