Add & edit a chart or graph

Make a nautical chart or graph

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the cells you want to include in your chart.
  3. Click Insert and then Nautical chart.

Change the chart type

Change the data range

The "data range" is the set of cells you want to include in your chart.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you desire to alter.
  3. At the right, click Setup.
  4. Under "Information range," click Grid Grid.
  5. Select the cells you want to include in your chart.
  6. Optional: To add more information to the chart, click Add together another range. Then, select the cells you want to add.
  7. Click OK.

Change the look of a chart

Change colors, lines, shapes, opacity & fonts

Add gridlines

You can add gridlines to your nautical chart to make the data easier to read.

Before y'all edit: Gridlines can be added to line, area, column, bar, scatter, waterfall, histogram, radar, or candlestick charts.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart y'all desire to change.
  3. At the right, click Customize.
  4. Click Gridlines.
  5. Optional: If your chart has horizontal and vertical gridlines, adjacent to "Apply to," choose the gridlines you want to modify.
  6. Make changes to the gridlines.

Tips:

  • To hide gridlines but keep axis labels, use the same colour for the gridlines and nautical chart background.
  • To customize the number of gridlines, in the box under "Major gridline count" or "Minor gridline count," enter a number.

Edit individual points & confined

Before you edit: Yous tin alter the points and bars of bar, cavalcade, line, scatter, and certain types of combo charts.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. On the chart, correct click the bar or point.
  3. Click Format Data Betoken.
  4. Make your changes.

Tip: You tin add together borders to bars and columns, but not to points or lines.

Change the groundwork, font & other options

The options yous tin can change depend on your nautical chart blazon. Learn more than about each chart.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Click Nautical chart way.
  5. Brand the changes you want.

Edit words

Edit titles

Y'all 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.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart y'all want to change.
  3. At the right, click Customize.
  4. Click Chart & axis championship.
  5. Next to "Blazon," cull which title you desire to change.
  6. Under "Title text," enter a title.
  7. Make changes to the title and font.

Tip: To edit existing titles on the nautical chart, double-click them.

Edit legends

The fable describes the data in the chart.

Before yous edit: Y'all tin can add together a fable to line, surface area, cavalcade, bar, scatter, pie, waterfall, histogram, or radar charts.

  1. On your reckoner, open up a spreadsheet in Google Sheets.
  2. Double-click the nautical chart you want to change.
  3. At the right, click Customize and thenLegend.
  4. To customize your fable, you tin alter the position, font, mode, and color.

Tip: To customize an individual legend item, double-click the text.

Add together or edit fable header

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to alter.
    • Tip: Make sure the text yous want to appear in the fable is the first row or column of your information ready.
  3. At the right, click Setup.
  4. 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 equally headers.

Tip: To customize an individual legend particular, double-click the text.

Motility, resize, or delete

Delete or move items on your chart

Delete items

You can delete some chart items similar titles, legends, data labels, and fault bars. To delete items:

  • To delete a specific item on the chart, double-click the item. And so, press delete or backspace.
  • To delete data labels or error bars, double-click i to select all. Then, click a third time to select the single data label/bar.

Tip: To remove other items on your nautical chart, double-click the chart to open up the side panel.

Move items

You lot tin movement some chart labels like the legend, titles, and individual data labels. You can't move labels on a pie nautical 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 nautical chart you lot want to move. Then, click and drag the item to a new position. You lot can besides use the keyboard arrows to move items.
  • To reset the position of a unmarried item, right click the detail. 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 Nautical chart way Reset layout.

Keyboard shortcuts

Yous can use your keyboard to navigate the chart speedily.

  • You can cycle through the layers of elements. To select dissimilar parts of a chart, press Enter.
  • To switch amidst chart elements, printing Tab.
  • To spring out one level, printing Esc.
  • To go into some other level, press Enter.
  • To cycle through various objects at that level, press Tab.
  • To move in the reverse management of "Tab," press Shift + Tab.

Move a chart

  1. On your computer, open up a spreadsheet in Google Sheets.
  2. Click the nautical chart you want to move.
  3. Drag the chart where you want it.

Tip: To move more than one item at the same fourth dimension, press CTRL or Command and click the items y'all want to move.

Resize a chart

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the chart you lot want to change.
  3. Drag the blue markers to resize the nautical chart.

Tip: To resize more than one detail by the same amount, press CTRL or Command and click the items yous desire to resize.

Related articles

  • Edit your chart's axes
  • Add & edit a trendline
  • Add together data labels or notes to a chart
  • Types of charts & graphs in Google Sheets

Was this helpful?

How tin can nosotros improve it?