How to make a graph in Google Sheets

Choose the chart that answers the question

A chart is not decoration. It should make one comparison easier than the table beneath it. If the question is “What changed each month?”, use a line chart. If it is “Which region sold the most?”, use a horizontal bar chart. If it is “Do higher ad budgets produce more leads?”, use a scatter chart.

Pie charts are useful only when the parts add to a valid whole and there are very few categories. For most operating data, bars are easier to compare.

• Time series → line chart
• Category comparison → bar or column chart
• Part-to-whole with 2–5 categories → pie or donut
• Relationship between two measures → scatter chart

Fix a chart that is reading the wrong range

If a chart has missing labels or an unexpected series, open the Chart editor and inspect Data range. A common mistake is selecting one column at a time and forgetting the label column.

For separate ranges, use Add range inside the selector. Keep every series the same length. A 12-month label range paired with an 11-month entry range will produce a misleading chart even when no error appears.

Make the result readable

Use a title that states the measure and period, for example “Monthly revenue, Jan–Jun 2026.” Keep gridlines light, avoid 3D effects, and use one accent color for the series that matters most.

If entries are currency or percentages, format the source cells first. The chart will usually inherit those formats and remain consistent when the data edits.