Chat with us, powered by LiveChat

Insert a Chart

How to Insert a Chart in Google Sheets

Insert a Chart

Charts are a great way to share data and information in a graphical way. The foundation of charts is the data they illustrate. Choosing the right data is the first and most important step in creating a chart.

Create a Chart

  1. Select a cell range containing data for a chart.

    Make sure to select column names too, if you want those to be included.

  2. Click Insert on the menu bar.
  3. Select Chart.
    Insert a Chart

    A chart is inserted with some default settings, and the Chart editor pane appears on the right.

  4. Click the Chart type list arrow in the Chart editor pane.

    The chart types are split into several categories. The first category is Suggested, which will show several chart types that work best for the selected data.

    Below the Suggested category, you can see other chart categories, starting with basic ones like line, area, and column. Further down the list you'll see more specialized types of charts.

  5. Select a chart type.

    Once you've determined the results you want your chart to display, choose the chart that best suits this purpose. The most popular charts are column, line, pie, and bar charts.

    Insert a Chart

The chart appears in the spreadsheet.

Chart Types in Sheets
Chart Types in SheetsColumn Column charts are used when you want to compare different values vertically side-by-side. Each value is represented in the chart by a vertical bar. If there are several series, each series is represented by a different color.
Chart Types in SheetsLine Line charts are used to illustrate trends over time. Each value is plotted as a point on the chart and is connected to other values by a line. Multiple items are plotted using different lines.
Chart Types in SheetsPie Pie charts are useful for showing values as a percentage of a whole. The values for each item are represented by different colors. Limit pie charts to eight sections.
Chart Types in SheetsBar Bar charts are just like column charts, except they display information in horizontal bars rather than in vertical columns.
Chart Types in SheetsArea Area charts are the same as line charts, except the areas beneath the lines are filled with color.
Chart Types in SheetsScatter Scatter charts are used to plot clusters of values using single points. Multiple items can be plotted by using different colored points or different point symbols.
Chart Types in SheetsMap Map charts allows to create geographical maps from the selected data
Chart Types in SheetsOther You can also create Waterfall, Histogram, Radar, Gauge, Scorecard, Candlestick, Organizational, Tree map, Timeline, and Table charts in Sheets.

Move a Chart

  1. Click the chart to select it.
  2. Click and drag the chart to a new location.
    Insert a Chart

Resize a Chart

  1. Click the chart to select it.
  2. Click and drag the chart's sizing handles to resize the chart.
    Insert a Chart

There! The chart is resized.

FREE Quick Reference

Click to Download