Chart Web Part From Jesper Halvorsen

A very common request or feature that individuals want on their SharePoint dashboard is the ability to display charts of data. It’s pretty much a guaranteed check mark on the list of requirements. The Office Web Components offer this but I totally cracked up when I read this post from Jesper Halvorsen

For a hobby project I needed the ability to dynamically generate charts based on lists items in SharePoint. Naive as I am, my first idea was to use Office Web Components to draw the charts – but getting OWC to work with SharePoint is enough to make a grown man cry It turned out to be a lot easier to draw the charts myself.
My idea was to make a chart web part that “site owners” could add to their sites and quickly configure, rather than an advanced web part that only developers could use. To achieve this, the web part uses views over a list as its data source – if you want to filter or group items, go ahead and create a new view for the chart.

While I haven’t tried these out yet I am totally going to. One thing I like about Jesper’s approach is making use of the list views for alternate chart views. This is a perferred approach if you are developing something for site owners since it allows them to modify the web part using a method they are already familiar with – creating / modifying lists views and modifying the web part properties.

Nice work Jesper! Really looking forward to checking this out.

This entry was posted in Microsoft Stuff. Bookmark the permalink.

3 Responses to Chart Web Part From Jesper Halvorsen

  1. Ian Morrish says:

    It is a shame Jasper didn’t know that the OWC’s have been wrapped in web parts already. It is very simple to graph daya from a SharePoint List with the Office Web Components.
    See http://www.wssdemo.com/Pages/OfficeWebParts.aspx

  2. Dave says:

    What are you talking about? Japer referenced his frustration with OWC’s in the explaination:

    “…Naive as I am, my first idea was to use Office Web Components to draw the charts – but getting OWC to work with SharePoint is enough to make a grown man cry… ”

    The other issue with OWC’s is that you have to have the same version of MS Office to view the charts (OWC11=Office 2003, OWC10=Office XP). Jaspers attempt creates a file anyone can view, and now with the Chart Web Part released by MS, you don’t need OWC unless you are making a BI dashboard, or need to drilldown further or in some way manipulate the data.

    Way to go Jasper!

  3. Rich says:

    So are there Sharepoint 2007 OWC web part betas available?