Docs Help

Working in a spreadsheet, you can choose from five main chart types, including column, bar, and pie charts. You can also save a chart as an image and insert it into a document. To create a chart, follow these steps:

1. From the Edit page of your spreadsheet, select the cells of data you'd like to include in the chart.

   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.

   

2. Select the Pie Chart icon in the menu bar or choose Insert > Chart. The 'Create chart' window appears.
3. In the 'What type?' section, select the type of chart you'd like to create: columns, bars, lines, pie, scatter, etc.

   

4. Enter labels for your chart in the following fields: Chart title (title of your chart), Horizontal (what the horizontal axis represents), Vertical (what the vertical axis represents). Here, you can also specify where you'd like the legend via the Legend drop-down menu.
5. In the 'What data?' section, make sure the range of data is correct and specify if you want data grouped by rows or columns.
   Note: If you included labels in your spreadsheet, you can specify that you want to use the first row and first column as labels. These settings are automatically selected when you include labels in Row 1 and Column A in your spreadsheet.
6. Preview your chart and edit as necessary.
7. Click Save chart. The chart appears in your spreadsheet.