April 17, 2007

Google Spreadsheets Adds Charts

Google Spreadsheets finally added charts. This feature has been developed for many months and was one of the biggest lacks from Google's spreadsheet application.

You can create more types of charts: columns, bars, lines, pie, scatter, add labels and a legend. Just select the columns you want to plot and click on the new chart icon. After inserting the chart in the spreadsheet, you can save it as a PNG image or edit it.

The charts are rendered as SVG in Firefox/Opera and VML in Internet Explorer, so they don't require plug-ins. As usually, Opera is not officially supported, so you'll find things that don't work as expected.



You can annotate cells and search using Google the text from a cell.

at

11 comments:

  1. MadGrinApril 18, 2007 at 2:48 AM

    Great news!
    I'm going to try now the new features! :D

    ReplyDelete
  2. ArunApril 18, 2007 at 6:49 AM

    They need to add auto-filter asap

    ReplyDelete
  3. AnonymousApril 18, 2007 at 11:39 AM

    you're pretty smart :-)

    ReplyDelete
  4. AnonymousApril 18, 2007 at 1:57 PM

    Should've used something like ComponentArt's WebChart,

    http://www.componentart.com/webchartlite/default.aspx

    Now those are some charts!

    ReplyDelete
  5. JayApril 18, 2007 at 3:22 PM

    Nice, I have been waiting for this, but what I really want to be able to do is to publish the chart to my Google personalised page and have it autoupdate.

    ReplyDelete
  6. GergőApril 18, 2007 at 9:28 PM

    It's a pity that does not export embedded chart to odf or xls.

    ReplyDelete
  7. Alex ChituApril 19, 2007 at 3:06 AM

    You're right, Amondó. Google Spreadsheets doesn't include the charts when you export the spreadsheet and it doesn't import the charts from xls or ods files. So the support for charts is really basic.

    ReplyDelete
  8. AnonymousApril 20, 2007 at 7:53 AM

    If you need more advanced charts (outside the Google spreadsheet as images), you can also use the free online charting service:

    www.chartAll.com

    Charts can be created from manually typed data, Google spreadsheets, data linked from url, etc.

    Includes basic charts, XY charts, XYZ 3D charts, Gauges, Geographical (mapping / GIS) charts, financial OHLC, and much more.

    regards
    david
    www.chartAll.com

    ReplyDelete
  9. JRApril 20, 2007 at 7:43 PM

    Jayant and others - you can publish your chart as you would publish any other sheet or range...
    just use the "PUBLISH" tab - go to "More Publishing Options" and choose the "HTML to Embed in a web page" format... That will give you iFrame code to embed in you page/blog...
    Use the undocumented &gidlines=false to turn off those grid lines...
    This will auto opdate ifyou chose that option on the main 'publish' tab.

    ReplyDelete
  10. UnknownApril 24, 2007 at 7:52 PM

    What about SVG support for WebKit?

    ReplyDelete
  11. AnonymousOctober 1, 2008 at 4:54 AM

    ms excel 2007 is way better

    ReplyDelete

Note: Only a member of this blog may post a comment.