Make a chart or graph
- On your computer, open a spreadsheet in Google Sheets.
- Select the cells you want to include in your chart.
- Click Insert Chart.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart 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 you want to include in your chart.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Setup.
- Under "Data range," click Grid .
- Select the cells you want to include in your chart.
- Optional: To add more data to the chart, click Add another range. Then, select the cells you want to add.
- Click OK.
Change the look of a chart
Change colors, lines, shapes, opacity & fonts
Add gridlinesYou 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 you want to change.
- At the right, click Customize.
- Click Gridlines.
- Optional: If your chart has horizontal and vertical gridlines, next to "Apply to," choose the gridlines you want to change.
- Make changes to the gridlines.
Tips:
- To hide gridlines but keep axis labels, use the same color for the gridlines and chart background.
- To customize 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 you want to change.
- At the right, click Customize.
- Click Chart style.
- Make the changes you want.
Edit words
Edit titlesYou 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 you want to change.
- At the right, click Customize.
- Click Chart & 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 the chart you want to change.
- At the right, click Customize Legend.
- To customize your legend, you can change the position, font, style, and color.
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- Tip: Make sure the text 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 customize an individual legend item, double-click 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 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, like an axis or a bar in a bar chart. To move items:
- To move an item to a new position, double-click the item on the chart 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 “Customize” tab, and clicking Chart style 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 amongst 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 the chart 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 you want to move.
- On your computer, open a spreadsheet in Google Sheets.
- Click the chart 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.