Excel and the Google Chart API
Intrigued by the new Google Chart API, I decided to explore how to integrate Excel with it. My approach was to add a WebBrowser ActiveX control to a worksheet and then manipulate the HTML elements of the document in the browser. A couple of samples of how multiple charts float in the web browser window:
and
Another interesting consequence of this approach is that one can click-and-drag any of the charts from the browser window to the worksheet. This results in a static image of the chart.
The preliminary work is at
Using the Google Chart API with Microsoft Excel
http://www.tushar-mehta.com/publish_train/xl_vba_cases/excel_google_chart_api/index.htm
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
Leave a comment