Edit and format your chart
Google Sheets lets you, and any user who can edit your spreadsheet, format your chart in different ways so that it’s displayed how you want it.
In View mode, you can see information about your chart but you can’t edit it. To see information about an element on your chart, hover over the element.
- Click on a chart.
- On the right, select the pencil icon.
- Click on the part of the chart that you’d like to change:
- Chart title: Change the font style, size, or color.
- Horizontal or vertical axis labels: Change the font style, size, or color.
- Legend: Change the font style, size, data series color, or position.
- Data series: Change the color, line thickness, dot size, or axis it belongs to. For example, click on a line you want to edit in a line chart or click on a bar in a bar chart.
- Chart background: Resize your chart, move it within the chart area, change the font or background color, or adjust the number of gridlines shown.
You can also right-click on a section of your chart to make an edit. For example, if you don’t see a legend, you can right-click and select Show legend.
Use Advanced Edit mode to customize your chart. To see a full list of customization options (some are not available in Quick Edit mode):
- Click on a chart.
- In the top right, click the arrow.
- Select Advanced edit.
- Select a tab:
Select new data from your spreadsheet, see recommended charts, and combine ranges horizontally or vertically if you’re creating a chart from multiple data ranges.
Change your chart type.
Customize your chart with the following options:
- Title text, size, and color.
- Legend text, size, and color, and location (top, bottom, right, or nowhere in your chart).
- Font used for text.
- Background color.
- Reverse: Flips the order of your data points.
- Log scale: Sets a logarithmic scale to your data.
- Maximize: Eliminates whitespace and zooms into your chart.
- Compare mode: Adds tooltips that show the values of all series at a given point in your chart.
- Plot null values (line charts only): Includes data points with no given value. If this option is checked, the chart will be drawn to connect all points, even when there's a blank value for a specific point. If it’s unchecked, holes will appear in the chart where there isn't data.
- Smooth (line charts only): Removes angles in a line chart.
Choose to customize the horizontal or vertical axis with the following options (options vary based on the axis you’re customizing):
- Label text, size, and color
- Slant labels
- Number format (prefix/suffix)
- Set minimum and maximum axis values. If you’re setting a minimum or maximum that cuts off part of your data set, check the box next to “Allow bounds to hide data.”
To select which series you want to customize, choose the series from the drop-down list. Customize a data series with the following options:
You may see more or fewer options since some customization options aren’t relevant for certain charts.
- Line thickness
- Point size
- Point shape
- Data labels
Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.