Since I posted the previous version of the solution that utilizes the Google Chart Tools / Interactive Charts (aka Visualization API), Google has updated their API and made the previous version more or less obsolete.

This is a solution for creating charts directly from SharePoint lists using Google Visualization API.

Google had a fun little commerical during Superbowl, Parisian Love, that got a lot of notice. I’ve recreated the same type of thing to talk about community in SharePoint. If you’d like to create your own story, you can too. Have fun. — Mark

If you can make immediate use of charts and graphs in your SharePoint site, would it be worth two hours of your time to find out how to do it, no code required? I thought so. We look forward to seeing you tomorrow at 1:00pm EST for SharePoint Charts and Graphs: Part 02 (Sparklines).

There’s an interesting shift happening in how large companies are starting to present their products. A while back, Common Craft start putting their “In Plain English” videos on YouTube. These things are nice: simple graphics, simple language, possibly complex subjects broken down into consumable chunks.

There is a place for Google Apps, Google Sites and the web based apps they are offering… no doubt about it. But the constant comparison to SharePoint is getting old fast.

The script below, combined with such a list view, will plot a Google Chart showing those totals dynamically. The chart scale is automatically adjusted with the maximum value to be charted so it fits the designated size in the script. Once implemented, you can hide the list view web part so only the chart will render on the page. You can also play around with chart parameters within the script, to change chart type, style, size, colors or even build more complex charts. Take a look at the Google Chart API page for reference.