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
Ad
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?

