Make a chart or a sparkline

Updated November 13, 2026

Charts update when the numbers change, and Excel opens them as you left them.

Insert a chart

  1. Select the data, including its headings.
  2. On Insert, choose a type: Column, Bar, Line, Pie, Area, Scatter, Radar, Combo, Stock, Surface, Waterfall, Hierarchy or Statistic.
  3. Drag the chart where you want it, and drag its corners to resize it.

Style it

Select the chart to show Chart Design:

  • Change chart type, Switch row/column and Select data change what it shows.
  • Chart Styles and Change Colors change the look.
  • Chart title, Legend, Data table, Trendline and Error bars add or remove parts.
  • Move Chart puts it on its own sheet or another sheet.
  • Double-click part of a chart, such as an axis or a series, to format it.

Sparklines

  1. Select the cells to put them in.
  2. On Insert, under Sparklines, choose Line, Column or Win/Loss, and give the data range.

You can also type =SPARKLINE(B2:E2) in a cell. See Google Sheets functions.

Tips

  • To put a chart on a slide, select it and choose File › Send To…, then Cloud Slides.

Was this article helpful?