Google Sheets Chart Examples: Types, Uses, and Tips

Google Sheets chart examples include a line chart for monthly sales trends, a bar chart for comparing products, a pie chart for a small set of category shares, and a scatter chart for checking how two measurements relate. To create one in Google Sheets in a web browser, select your data, choose Insert > Chart, then use the Chart editor to select a chart type and adjust its setup and appearance.

Start with the question your chart should answer

A chart is useful when it makes a pattern, comparison, or relationship easier to see than it is in a table. Before choosing a chart type, decide what readers should notice: change over time, differences among groups, parts of a total, or the connection between two numeric measures. The same dataset can support several charts, but only some will make the intended point quickly.

For example, imagine a small sales table with months in the first column and sales in the second:

Month	Sales
January	120
February	150
March	135
April	190

A line chart emphasizes the rise and dip across time. A column chart makes the month-to-month amounts easier to compare. Neither is automatically better; the right choice depends on whether the story is a trend or a set of distinct values.

Prepare the data before inserting a chart

Organize chart data in a simple rectangular range. Put a descriptive heading at the top of each column, place one observation or category on each row, and keep each column to one kind of information. In the sales example, the month labels belong in one column and numeric sales values in another. Clear headers help Sheets identify series names and can appear in the chart legend.

Avoid merged cells in the chart’s source range; they can make the range harder to interpret.
Keep explanatory notes and subtotals outside the data block so they are not mistaken for observations.
Check that numbers are stored as numbers and dates as dates, rather than text that only looks numeric.
For a chart with several series, use one category column followed by one column per series, such as month, online sales, and in-store sales.

To make a chart, select the data range including its headings and choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually on the right. On the Setup tab, check the data range, the X-axis, and the series. If the rows and columns have been interpreted backwards, use the option to switch rows and columns. You can also change the chart type from the Setup tab.

Line charts for changes over time

A line chart is a strong choice when the horizontal axis follows a meaningful order, especially dates or time periods. Use it for weekly website visits, monthly expenses, daily temperatures, or a project’s progress over time. In the sales example, the line makes the overall upward movement visible while retaining the March dip.

Line charts become harder to read when too many series overlap. If comparing several products, use a small number of clearly named lines and a consistent time scale. If the values are separate categories rather than a continuous sequence, a bar or column chart may be clearer. Avoid connecting unrelated categories with a line simply because the labels can be arranged in an order.

Column and bar charts for comparisons

Column charts use vertical bars; bar charts use horizontal bars. Both work well for comparing values across categories, such as sales by product, sign-ups by channel, or survey responses by department. Choose a column chart when category names are short and the number of categories is manageable. A horizontal bar chart often gives long labels more room and is a practical choice when ranking many items.

For instance, a table of product names and quarterly revenue could be displayed as bars, making the highest and lowest products easy to identify. If every product has several quarterly values, a grouped chart can compare periods within each product. A stacked chart instead emphasizes how subcategories contribute to each total. A 100% stacked chart is suited to comparing proportions, not absolute totals: bars become the same length, so their total sizes are no longer shown.

Combo charts for different kinds of measures

A combo chart combines chart forms, commonly columns for one series and a line for another. It can help when a report needs to show monthly revenue alongside a rate, such as conversion percentage, because the two measures answer related but different questions. In the Chart editor, choose a combo chart under Setup, then use Customize and the Series controls to adjust how individual series appear. Depending on the chart and available settings, a series can be assigned to a different axis.

Use a second axis carefully. A line may look dramatic or flat depending on the scale chosen for that axis, even though the underlying data has not changed. Label both axes with their measures and units, and explain the scale when readers might misread it. If the measures are unrelated, separate charts are usually easier to interpret.

Pie and doughnut charts for parts of a whole

Pie and doughnut charts show how categories make up a single total. They are most readable when there are only a few categories, each category is a genuine part of the same whole, and the values are nonnegative. A survey showing the share of respondents choosing one of four options is a reasonable example. A list of monthly sales is not: the months are time periods, not slices of one meaningful whole.

Many small slices, similar values, or long labels make angles difficult to compare. A bar chart is generally a better option when the reader needs to rank categories or distinguish values that are close. In Sheets, select the category and value columns, insert a chart, and choose a pie or doughnut chart from Setup. The Customize tab provides presentation options such as labels and legend placement, though the available controls depend on chart type.

Scatter charts and histograms answer different questions

A scatter chart plots paired numeric values, one measure on each axis. Use it to explore whether two variables move together, such as advertising spend and orders, or plant height and days since planting. Each row should contain a matched pair of observations. A scatter plot can reveal a pattern or outlier, but a visible association by itself does not show that one variable caused the other.

A histogram, by contrast, summarizes the distribution of one numeric variable by grouping values into ranges, or bins. It can show whether delivery times cluster around a typical range or whether test scores have a long tail. It does not preserve individual observations as separate labeled categories. If the bins make a distribution look misleadingly smooth or lumpy, adjust the bin settings in the chart’s Customize options where available, and consider showing a table of counts alongside it.

Customize labels, legends, and colors

Use the Chart editor’s Customize tab to add a chart title, axis titles, labels, and other visual adjustments. The exact controls vary by chart type. A useful title states the subject and, when helpful, the time period; axis titles clarify units such as dollars, hours, or percent. A legend is important when a chart contains multiple series, but it can be unnecessary when direct labels identify the data clearly.

Use a consistent color for the same series across related charts.
Choose colors with enough contrast and do not make color the only way to distinguish important categories.
Keep gridlines and decorative effects restrained so the data remains prominent.
Check whether labels overlap or become too small when the chart is resized.

Changing colors can make a chart more attractive, but clarity is the priority. For instance, using a different bright color for every month may distract from a simple time trend. If a chart is copied into a report, verify that its title, legend, and labels remain readable at the size readers will see.

Common chart problems and how to fix them

If a chart shows the wrong categories or treats numbers as labels, return to Setup and check the data range, X-axis, and series. Confirm that the heading row and category column are included, and try switching rows and columns if Sheets has guessed the orientation incorrectly. A chart may also omit newly added rows if its data range does not include them; edit the range in Setup to include the new data.

Unexpected gaps can come from blank cells, missing values, or dates stored as text. Check the source cells before changing the chart style. If the chart is crowded, reduce the number of categories, split the data into a few focused charts, or use a horizontal bar chart for long labels. A common misconception is that a more complex chart is more informative. Usually, the simplest chart that answers the question is easier to understand and explain.

Sharing and using charts outside the sheet

A chart in Google Sheets is connected to its source data, so changes to the data can update the chart. You can copy a chart and paste it into another Google document or presentation; the paste options may allow it to remain linked to the spreadsheet or be pasted without a link. A linked chart can be updated from its source, while an unlinked copy will not reflect later spreadsheet changes. Check the destination document’s update prompt when the source data changes.

To share the chart with someone, sharing the spreadsheet is often the simplest approach, but access permissions apply to the file, not just to the chart. If you download or export a chart for a report, inspect the exported result for legibility and confirm that the intended data is visible. Google Sheets and Microsoft Excel both offer common chart types, but their chart editors and some formatting controls differ; instructions for one program do not always match the other.

Frequently Asked Questions

How do I make a chart in Google Sheets?
Select the data, including its headers, and choose Insert > Chart. In the Chart editor, use Setup to choose the chart type and verify the data range, axes, and series. Use Customize for titles and appearance.

Which Google Sheets chart is best for comparing categories?
Use a column chart for a modest number of categories with short names, or a bar chart when labels are long or there are many categories. If the focus is a change over time, consider a line chart instead.

How do I add a title to a Google Sheets chart?
Open the chart editor, select Customize, and open Chart & axis titles. Choose the chart title or an axis title and enter the text. Available title controls can vary with the chart type.

Why is my Google Sheets chart not showing all my data?
Check the chart’s data range on the Setup tab and extend it to include the missing rows or columns. Also check for blank cells, text-formatted numbers, or an incorrect X-axis or series selection.

Can I use a Google Sheets chart in Google Slides?
Yes. Copy the chart in Sheets and paste it into Slides. Depending on the paste option, you can link it to the spreadsheet so it can be updated or insert it without a link.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.