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.

View mode

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.

Quick Edits

To make small, fast edits, use Quick Edit mode. You can use Quick mode on charts like line, area, bar, column, pie or candlestick.

  1. Click on a chart.
  2. On the right, select the pencil icon.
  3. 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.

Quick Edit mode is not available for all chart types. If you don’t see the Edit mode button in the top left, use Advanced Edit mode to format your chart.

Advanced Edits

Use Advanced Edit mode to customize your chart. To see a full list of customization options (some are not available in Quick Edit mode):

  1. Click on a chart.
  2. In the top right, click the arrow.
  3. Select Advanced edit.
  4. Select a tab: Start

    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.

    Charts

    Change your chart type.

    Customize

    Chart

    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.

    Axis

    Choose to customize the horizontal or vertical axis with the following options (options vary based on the axis you’re customizing):

    • Title
    • Label text, size, and color
    • Slant labels
    • Gridlines
    • Number format (prefix/suffix)
    • Scale
    • 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.”

    Series

    To select which series you want to customize, choose the series from the drop-down list. Customize a data series with the following options:

    • Color
    • Line thickness
    • Point size
    • Point shape
    • Data labels
    You may see more or fewer options since some customization options aren’t relevant for certain charts.

Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.

How helpful is this article:

Feedback recorded. Thanks!
  • Not at all helpful
  • Not very helpful
  • Somewhat helpful
  • Very helpful
  • Extremely helpful