Types of charts & graphs in Google Sheets

To learn about a chart and how to use it, use the table below.

Learn how to add a chart to your spreadsheet.

Line chart  Line

Use a line chart to look at trends or data over a time period.

Combo chart  Combo

Use a combo chart to show each data series as a different marker type, like a column, line, or area line.

Area chart  Area

Use an area chart to track one or more data series graphically, like changes in value between categories of data.

Related charts: Stacked area chart, 100% stacked area chart, Stepped area chart, Stacked stepped area chart , 100% stacked stepped area chart

Column chart  Column

Use a column chart to show one or more categories, or groups, of data, especially if each category has subcategories.

Related charts: Stacked column chart, 100% stacked column chart

Bar chart  Bar

Use a bar chart to show the difference between the data points for one or more categories.

Related charts: Stacked bar chart, 100% stacked bar chart

Pie chart  Pie

Use a pie chart, also known as a pie graph, to show data as "slices of pie," or proportions of a whole.

Related charts: 3D pie chart, Donut chart

Scatter chart  Scatter

Use a scatter chart to show numeric coordinates along the horizontal (X) and vertical (Y) axes and to look for trends and patterns between two variables.

Related charts: Bubble chart

Sparklines  Sparklines

Use a sparkline chart to show and compare one or more categories of data, like a time period.

Histogram  Histogram

Use a histogram chart to show the distribution of a data set across different buckets.

Candlestick chart  Candlestick

Use a candlestick chart to show an opening and closing value overlaid on a total variance, like changes in stock value.

Organizational  Organizational

Use an organizational chart, also called an org chart, to show the relationship between members of a company, group of people, or family tree.

Tree map chart  Tree map

Use a tree map to show a data tree, where objects are organized into parent-child hierarchies.

 Geo

Use a geo chart to show a map of a country, continent, or region. The values for each location will be shown with colors.

 Waterfall

Use a waterfall chart to show how later values add or subtract from a starting value.

 Radar chart

Use a radar chart to show one or more variables in a two-dimensional graph, with one spoke for each variable.

 Gauges

Use gauges to show numeric values or measurements within a range. Each value produces a gauge, so you can compare and contrast measurements.

 Annotated timeline

Use an annotated timeline to show an interactive time series line chart with the option to add notes.

 Table

Use a table chart to turn your spreadsheet table into a chart that can be sorted and paged. Table charts are often used to create a dashboard in Google Sheets or embed a chart in a website.

Was this article helpful?
How can we improve it?