Google Spreadsheets gain sophisticated charting

Google Spreadsheets gain sophisticated charting

Summary: Excel might be able to crunch serious numbers for accountants, but new charts make Google Spreadsheets a better choice for displaying data on the Web.

SHARE:

Having just completed a Google Apps training session for one of my clients today, I tucked away Google's announcement of improved charts within their Spreadsheets App for a followup session. While Excel remains king of the spreadsheets, the revised charting and other recent enhancements to the editor and interface make Google Spreadsheets a competitive tool for most users.

Google introduced the new features Tuesday in a blog post and the movie below shows the enhancements.

And while Excel may be king of the spreadsheets, Google has a few tricks up its sleeve. The organization chart, for example, is generated dynamically based on data in the spreadsheet (click here to see an example). Excel requires users to create org charts as SmartArt graphics with no data-driven or programmatic interfaces. Similarly, the longitudinal representations of data are quite powerful. When combined with a form or other interface to add data which are updated in real time and reflected immediately on the chart (which can be embedded in a web page), then there is a lot of functionality that leverages the cloud in ways that Excel just can't. Click here for an example of the "motion chart" (longitudinal analysis).

In fact, I would argue that if your goal is generally to represent data on the Web and your needs don't extend to really sophisticated database-driven analytics, then Google Spreadsheets is actually a better choice than Excel. With virtually any other tool, making dynamic, data-driven charts appear on the Web is no small feat. With these new charting features, it's as easy as entering the data and embedding the chart on a Web page or blog.

I've argued before that Google is better off not trying to create an Office clone in its Apps suite. Rather, they need to focus on exploiting the features of a cloud-based tool that Office just can't match (at least not without SharePoint behind it). In this case, they did just that with attractive, dynamic charts that are simple to create and embed.

Topics: CXO, Apps, Cloud, Google, Software, IT Employment

Christopher Dawson

About Christopher Dawson

Chris Dawson is a freelance writer, consultant, and policy advocate with 20 years of experience in education, technology, and the intersection of the two.

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

7 comments
Log in or register to join the discussion
  • As publishing documents becomes the norm, and 8.5 x 11 paper becomes a

    thing of the past, Microsoft Office is looking more ridiculous every day.
    DonnieBoy
    • sure sure

      @DonnieBoy yeah.... whatever dude
      patibulo
      • patibulo: Where is the argument? Why is baroque office suite focused on

        printing for 8.5 x 11 paper still relevant?
        DonnieBoy
    • RE: Google Spreadsheets gain sophisticated charting

      @DonnieBoy

      Replying below your reply to patibulo:

      It's still relevant because people still print. Paperless is a nice idea that's still years away from reality.
      clfitz
  • Man that is some FUGLY charting

    Excel Web Apps

    http://webworkerdaily.files.wordpress.com/2009/09/microsoft-excel-web-app.png
    hubivedder
  • Good article

    There's no way Google will every make software as good (or even as functional) as MicroSoft. Most of Google's stuff just sounds "cool" on paper but they really offer nothing useful. Instead, Goolge should concentrate on intergrating this to Android before the iPhone kills it.
    iPad-awan
  • Metlynx

    High-level MATLAB-language processing with seamless Google Spreadsheets integration: <br><br><a href="http://www.metlynx.com" target="_blank" rel="nofollow">http://www.metlynx.com</a>. <br><br>It's immensely useful to those of us who need to apply sophisticated math to our spreadsheets, but improved charting will help too. <br><br><a href="http://www.youtube.com/watch?v=3CI_izlFad8" target="_blank" rel="nofollow">http://www.youtube.com/watch?v=3CI_izlFad8</a>
    joseph4321