Create and Design Charts
Create Chart and Insert to a Spreadsheet
1. Select a range of cells to display the data in a chart
2. Do one of the following:
- On the Formatting Toolbar, click on the Insert chart button
- From the Menu Bar, go to Insert menu > choose Charts
3. In the Chart Editor dialog box, do the following:
- In Start tab, Google has recommended some charts based on the type of data contained in the selected range
- In Charts tab, other types of charts are classified in different categories such as Line, Area, Column, Bar, Scatter, Pie, Trend and More
- In Customize tab, tools are used to further customize the chart
4. Select any desired charts
5. If necessary, customize the chart under Customize tab
6. Click Insert to place the chart into the spreadsheet
Move the Chart to Different Area in the Spreadsheet
1. Click on the chart
2. Place the mouse on the horizontal gray bar
3. Drag the chart to a new location
Display the Chart in its Own Sheet
1. Click on the down arrow next to the chart number on the top of the chart
2. Select Move to own sheet from the drop down menu
3. The chart is moved to a new sheet
Other Chart Formatting Options
Other options on the drop down menu on the chart:
1. Edit chart – to go back to the Chart Editor dialog box
2. Delete chart – to remove the chart altogether
3. Save image – to save the chart as an image
4. Publish chart – to publish the chart
