Add & edit a chart or graph

Make a 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 Chart.

Change the chart type

Change the data range

The "information range" is the set of cells you desire to include in your chart.

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

Change the await of a nautical chart

Change colors, lines, shapes, opacity & fonts

Add gridlines

Y'all can add gridlines to your chart to make the information easier to read.

Before you edit: Gridlines can be added to line, area, cavalcade, bar, scatter, waterfall, histogram, radar, or candlestick charts.

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

Tips:

  • To hide gridlines but go on axis labels, utilize the same color for the gridlines and chart background.
  • To customize the number of gridlines, in the box nether "Major gridline count" or "Small gridline count," enter a number.

Edit individual points & bars

Before you edit: You can modify the points and bars of bar, cavalcade, line, besprinkle, and certain types of philharmonic charts.

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

Tip: Yous can add borders to bars and columns, but not to points or lines.

Change the background, font & other options

The options yous tin can change depend on your chart type. Acquire more than nearly each chart.

  1. On your estimator, 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 style.
  5. Brand the changes y'all desire.

Edit words

Edit titles

You can change titles, subtitles, or title fonts.

Earlier y'all edit: Titles and subtitles can exist added to line, surface area, cavalcade, 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 you want to change.
  3. At the correct, click Customize.
  4. Click Chart & centrality championship.
  5. Next to "Type," cull which title you want to change.
  6. Under "Title text," enter a title.
  7. Make changes to the title and font.

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

Edit legends

The legend describes the data in the chart.

Before you edit: Yous can add a fable to line, surface area, column, bar, besprinkle, pie, waterfall, histogram, or radar charts.

  1. On your figurer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to modify.
  3. At the right, click Customize and thenLegend.
  4. To customize your legend, you tin can change the position, font, manner, and color.

Tip: To customize an private legend particular, 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 desire to change.
    • Tip: Make certain the text you want to appear in the fable is the first row or cavalcade of your information gear up.
  3. At the right, click Setup.
  4. Choose an option:
    • If headers are in rows: Click Use row North as headers.
    • If headers are in columns: Click Switch rows / columns and Use column N equally headers.

Tip: To customize an private fable detail, double-click the text.

Move, resize, or delete

Delete or move items on your nautical chart

Delete items

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

  • To delete a specific item on the nautical chart, double-click the item. Then, printing delete or backspace.
  • To delete data labels or mistake bars, double-click one to select all. And then, click a third time to select the single information characterization/bar.

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

Move items

You lot can move some chart labels like the fable, titles, and individual data labels. You can't movement labels on a pie chart or whatever parts of a nautical chart that prove data, like an axis or a bar in a bar chart. To motion items:

  • To move an item to a new position, double-click the item on the chart you want to movement. And then, click and drag the item to a new position. You lot tin can also utilize the keyboard arrows to move items.
  • To reset the position of a single item, correct click the detail. And so, 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 lot can utilise your keyboard to navigate the chart rapidly.

  • Y'all can wheel through the layers of elements. To select unlike parts of a chart, press Enter.
  • To switch amongst chart elements, printing Tab.
  • To jump out i level, press Esc.
  • To go into some other level, press Enter.
  • To cycle through various objects at that level, press Tab.
  • To move in the opposite direction of "Tab," press Shift + Tab.

Motion a nautical chart

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

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

Resize a chart

  1. On your calculator, open a spreadsheet in Google Sheets.
  2. Click the nautical chart you desire to modify.
  3. Drag the blue markers to resize the chart.

Tip: To resize more than one item past the same amount, press CTRL or Command and click the items you want to resize.

Related articles

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

Was this helpful?

How can we improve it?