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
- Select the data, including its headings.
- On Insert, choose a type: Column, Bar, Line, Pie, Area, Scatter, Radar, Combo, Stock, Surface, Waterfall, Hierarchy or Statistic.
- 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
- Select the cells to put them in.
- 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.