Make a chart or graph
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells that you want to include in your chart.
- Click Insert
Chart.
Chart.- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart that you want to change.
- At the right, click Setup.
- Under 'Chart type', click the Down arrow
.
- Choose a chart from the list.
.The 'data range' is the set of cells that you want to include in your chart.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart that you want to change.
- At the right, click Setup.
- Under 'Data range', click Grid
.
- Select the cells that you want to include in your chart.
- Optional: To add more data to the chart, click Add another range. Then, select the cells that you want to add.
- Click OK.
.Change the look of a chart
Change colours, lines, shapes, opacity & fonts
You can add gridlines to your chart to make the data easier to read.
Before you edit: Gridlines can be added to line, area, column, bar, scatter, waterfall, histogram, radar or candlestick charts.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart that you want to change.
- On the right, click Customise.
- Click Gridlines.
- Optional: If your chart has horizontal and vertical gridlines, next to 'Apply to', choose the gridlines that you want to change.
- Make changes to the gridlines.
Tips
- To hide gridlines but keep axis labels, use the same colour for the gridlines and chart background.
- To customise the number of gridlines, in the box under 'Major gridline count' or 'Minor gridline count', enter a number.
Before you edit: You can change the points and bars of bar, column, line, scatter and certain types of combo charts.
- On your computer, open a spreadsheet in Google Sheets.
- On the chart, right-click the bar or point.
- Click Format data point.
- Make your changes.
Tip: You can add borders to bars and columns, but not to points or lines.
The options you can change depend on your chart type. Learn more about each chart.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart that you want to change.
- On the right, click Customise.
- Click Chart style.
- Make the changes that you want.
Edit words
You can change titles, subtitles or title fonts.
Before you edit: Titles and subtitles can be added to line, area, column, bar, scatter, pie, waterfall, histogram, radar, candlestick or treemap charts.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart that you want to change.
- On the right, click Customise.
- Click Chart and axis title.
- Next to 'Type', choose which title you want to change.
- Under 'Title text', enter a title.
- Make changes to the title and font.
Tip: To edit existing titles on the chart, double-click them.
The legend describes the data in the chart.
Before you edit: You can add a legend to line, area, column, bar, scatter, pie, waterfall, histogram or radar charts.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click on the chart that you want to change.
- On the right, click Customise
- To customise your legend, you can change the position, font, style and colour.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click on the chart you want to change.
- Tip: Make sure that the text that you want to appear in the legend is the first row or column of your data set.
- At the right, click Setup.
- Choose an option:
- If headers are in rows: Click Use row N as headers.
- If headers are in columns: Click Switch rows/columns and Use column N as headers.
Tip: To customise an individual legend item, double-click on the text.
Move, resize or delete
Delete or move items on your chart
Delete items
You can delete some chart items like titles, legends, data labels and error bars. To delete items:
- To delete a specific item on the chart, double-click on the item. Then, press delete or backspace.
- To delete data labels or error bars, double-click one to select all. Then, click a third time to select the single data label/bar.
Tip: To remove other items on your chart, double-click the chart to open the side panel.
Move items
You can move some chart labels like the legend, titles, and individual data labels. You can't move labels on a pie chart or any parts of a chart that show data, such as an axis or a bar in a bar chart. To move items:
- To move an item to a new position, double-click on the item on the chart that you want to move. Then, click and drag the item to a new position. You can also use the keyboard arrows to move items.
- To reset the position of a single item, right-click the item. Then, click Reset layout.
- To reset to position of all items, open the chart editor by double-clicking on the chart, going to the 'Customise' tab and clicking Chart style
Reset layout.
Reset layout. Keyboard shortcuts
You can use your keyboard to navigate the chart quickly.
- You can cycle through the layers of elements. To select different parts of a chart, press Enter.
- To switch between chart elements, press Tab.
- To jump out one level, press Esc.
- To go into another level, press Enter.
- To cycle through various objects at that level, press Tab.
- To move in the opposite direction of 'Tab', press Shift + Tab.
- On your computer, open a spreadsheet in Google Sheets.
- Click on the chart that you want to move.
- Drag the chart where you want it.
Tip: To move more than one item at the same time, press CTRL or Command and click the items that you want to move.
- On your computer, open a spreadsheet in Google Sheets.
- Click on the chart that you want to change.
- Drag the blue markers to resize the chart.
Tip: To resize more than one item by the same amount, press CTRL or Command and click the items you want to resize.