Types of charts & graphs in Google Sheets
To learn about a chart and how to use it, use the table below.
Use a line chart to look at trends or data over a time period.
Use a combo chart to show each data series as a different marker type, like a column, line, or area line.
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
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
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
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
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
Use a sparkline chart to show and compare one or more categories of data, like a time period.
Use a histogram chart to show the distribution of a data set across different buckets.
Use a candlestick chart to show an opening and closing value overlaid on a total variance, like changes in stock value.
Use an organizational chart, also called an org chart, to show the relationship between members of a company, group of people, or family tree.
Use a tree map to show a data tree, where objects are organized into parent-child hierarchies.
Use a geo chart to show a map of a country, continent, or region. The values for each location will be shown with colors.
Use a waterfall chart to show how later values add or subtract from a starting value.
Use a radar chart to show one or more variables in a two-dimensional graph, with one spoke for each variable.
Use gauges to show numeric values or measurements within a range. Each value produces a gauge, so you can compare and contrast measurements.
Use an annotated timeline to show an interactive time series line chart with the option to add notes.
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.