About

You're viewing one of 26,366 blog entries. Click here to read some more.

Other views

Recent Comments
Comments By...
Last 100 Entries
Read Chronologically
Random Entry
Random Image
View by Category
Mobile Edition


eXTReMe Tracker

Ad

Advertise Here



Friday, 07 December, 2007

Google Chart API

This is the coolest thing I've seen in a long time: Google Chart API.

The Google Chart API returns a PNG-format image in response to a URL. Several types of image can be generated: line, bar, and pie charts for example. For each image type you can specify attributes such as size, colors, and labels.

You can include a Chart API image in a webpage by embedding a URL within an IMG tag. When the webpage is displayed in a browser the Chart API renders the image within the page.

Here's a chart that is generated on the fly:

And here's the URL that creates it:

http://chart.apis.google.com/chart?cht=lc&chd=s:
pqokeYONOMEBAKPOQVTXZdecaZcglprqxuux393ztpoonkeggjp&chco
=FF0000&chls=4.0,3.0,0.0&chs=200x125&chx
t=x,y&chxl=0:%7CJun%7CJuly%7CAug%7C1
:%7C%7C20%7C30%7C40%7C50&chf=bg,s,efefef

You'll find more examples here.

I wonder how difficult it would be to write VBA code that analyzes an Excel chart, and then creates a Google Chart API URL to reproduce it?