Welcome to The Cloud. You’ll hear that just about everywhere these days. One of the biggest software categories to make the move to the Web is document-based productivity tools. The unquestioned leader in that realm is Google Docs, which lets you create documents, spreadsheets, and presentations.
But to truly qualify as “desktop replacement” software, you’re going to need to be able to do everything that you can with your current editor of choice. Today we’re going to take a look at a common need from a spreadsheet program – chart creation.
First Of All, The Data
Ok, so it may seem a little obvious, but before you can create a chart with Google Docs, you’re going to need some data to chart. Specifically, you’re going to need some numbers. See, that’s one place where I ran into some issues when I started to create my charts. If you look at the screenshot below, you’ll notice that one of the columns is the name of the laptop I’m listing information for.
If I include that column within the scope of my chart data, I won’t have access to any of the charts, Google Docs will only offer me the option of showing the selected data in table format. So make sure your data consists of purely numbers.
Configuring Your Chart
Now that you’ve got the right data together, clicking on the Chart button in the toolbar will bring up the Chart Editor. You’ve got a lot of control here, but it isn’t overwhelming. Clear icons and succinct labels help un-complicate the UI. If the initial options aren’t enough, you have two more tabs of options: Charts and Customize.
This is really the biggest step. Remember to explore the Customize tab once you’ve settled on the chart type you’d like, because the options there change depending on the type of chart you’ve selected.
Google Docs offers over 8 different chart types to choose from. You’ve got everything from the traditional bar, line, and pie graphs, to more interesting options like scatter plots and trend graphs.
As I mentioned before, chart customization options change depending on the type of chart you select, but there are several that stay the same. From the Customize tab you can add a title to your chart, control the layout of the legend, and the labels on both the vertical and horizontal axises. The Features section of the Customize tab is where you get custom options for each chart style. And below that, you have some basic Style options, controlling the colors of the chart and the background.
Exporting Your Chart
Now that, using the data that you put in earlier, you’ve created a chart to your liking, it’s time to share it with the world. Google Docs offers two options for publishing the chart by itself. After inserting the chart onto your spreadsheet, clicking on it once will reveal a title bar. Clicking that title will reveal a dropdown menu of options, one of which is “Publish chart…”.
So you can see, Google Docs offers simple, easy-to-use chart creation tools for free. A lot of businesses, and consumers, with light office-type productivity needs are finding Google Docs to be a wonderful substitute for a full-blown office suite. Maybe it’ll be like that for you. You can safely say creating charts is a breeze.