Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Charts can be an excellent way to display numeric data in a graphical format. This can make it easier to analyze trends and comparisons. Let's work with our Energy Saving Plan spreadsheet on the Energy Savers sheet. To create a chart from scratch, we simply insert it either from the Insert menu, where you will see a list of chart names. Or if you prefer, click the Charts button on the Toolbar to see a list of chart icons representing the different types of charts we can insert. Let's select a two-dimensional Pie Chart. Notice what happens here.
A table with sample data is added for us. It's a simple matter now of editing that data. Let's type in 22 for the year 2007 and press Return. And in cell A2, we'll change it from Region 1 to West. When you press Return that's updated as well. We might also want to rename our table and chart in the Sheets pane. Double click the table name and type in West. We can do the same for our chart, when we press Return, notice the chart name appears at the top of our chart and our data is selected in our table. To deselect everything, click anywhere on the canvas to see the end result.
Now, if you already have data entered into a table, you can use that data to create a chart. Let's switch to our Utility Costs sheet. Here we have two tables containing data. Let's work with our Utility Costs by Type. One option is to select the table here in the Sheets pane and use this data to create a chart. Notice however that the different types include a Total column. So in this case, we might want to select the data to be used in our chart first, so we'll click and drag from the cell in the top left corner across to the Water column and down to the last row for 2009.
Now with our data selected, we can click the Charts button, this time we'll select a two-dimensional Column Chart. When we do this, the chart appears using the data we selected in our table. Of course, we probably want to rename this one as well. Double click the chart name and type in Costs by Type. When you press Return, that's updated in the chart. Notice also that the Chart Inspector opens up, in case we need to make any changes to the chart properties. We can close this up if we don't intend on using it, and deselect our table and our chart by clicking anywhere in the canvas.
So whether you use existing data in the table or add your own on the fly, inserting a chart can simplify the task of analyzing trends and comparisons.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90826 Viewers
80 Video lessons · 138034 Viewers
59 Video lessons · 56818 Viewers
52 Video lessons · 70450 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.