|
|
Charts are a convenient way to analyze spreadsheet data visually and come built-in to Google Docs. There are 7 standard types of charts to choose from: line, area, column, bar, scatter, pie, and trend. In addition, there are even more options to choose from under More in the Chart Editor.
Data displayed in charts is selected from the spreadsheet and updated whenever the spreadsheet is modified. This way your chart always has the most accurate information.
To create a chart in your spreadsheet, follow these steps:
- From the Edit page of your spreadsheet, select the cells of data you'd like to include in the chart.
Please note: It helps to label the data in your spreadsheet before creating a chart. For example, if you want to chart your expenses, you might have a row of numbers labeled 'Rent' and another labeled 'Groceries.' Then you might label columns by month or week, etc. These labels will appear automatically in the window where you create and preview your chart.
- Go to the Insert menu and select Chart. The 'Chart Editor window appears.
In the Data section, make sure the range of data is correct and specify if you want to switch rows/columns. You can even select multiple ranges.
Note: If you included labels in your spreadsheet, you can specify that you want to use the second row and first column as labels.
- Under the 'Charts' tab, select the type of chart you'd like to create: line, area, column, bars, scatter, etc.
- Enter labels for your chart in the following fields: Chart title (title of your chart), Layout of the legend, Horizontal (what the horizontal axis represents), Vertical (what the vertical axis represents). Here, you can also specify the Features and Style of various chart components.
- Preview your chart and edit as necessary.
- Click Insert. The chart appears in your spreadsheet.
|
| |
|
|
 |
|
|
