Google Sheets web app (rolling service) · Analysis and charts · Beginner

Create and Edit a Chart in Google Sheets

Choose and create a chart for a business question; Maintain chart series, axes, labels and trend lines in Google Sheets with a reproducible practice example and outcome checks.

Documentation-reviewed candidate; native application verification not performed. · Editorial standards

Quick answer

Select a labeled source range and choose Insert > Chart. Use Setup for the range and chart type, then Customize for readable titles, axes, legend and a suitable trendline. A chart is useful only if its series still point to the intended data after edits.

Prepare the business question and fixture

Use the desktop web app with edit access to a private native spreadsheet. The controls below are desktop controls, not a mobile walkthrough. No special Workspace edition is required for this ordinary chart exercise.

The question is: how did monthly order counts change, and how did they compare with plan? Enter this table at A1:

Month	Orders	Plan
Jan	100	120
Feb	150	140
Mar	125	160

A line chart suits the ordered monthly sequence. A column chart would emphasize month-by-month comparisons. A pie chart would answer a different question about shares, not this trend. These are design choices for the fixture, not claims that Sheets automatically chooses the best chart.

Create and maintain the series

Select A1:C4 and choose Insert > Chart.
Double-click the chart to open its editor. Under Setup, choose a line chart.
Check Data range is A1:C4, the month labels are the horizontal domain, and row 1 supplies the series names. Enable Use row 1 as headers if necessary.
Check the legend distinguishes Orders and Plan. If the orientation is wrong, inspect Switch rows / columns rather than changing source values.
To rehearse a range change, narrow the chart’s range to A1:B4, using the range picker and OK. Plan should disappear. Restore A1:C4 and confirm both series return.

This range exercise is also a way to diagnose missing series: a header and numeric column must be inside the chart range. The March values should be 125 and 160, not the column totals.

Make axes and labels interpretable

In Customize > Chart & axis title, select the relevant title type and enter Orders versus plan, Month, and Order count. Under Legend, choose a position that leaves the plot readable. Under Vertical axis, set a minimum of zero for a straightforward count comparison; do not impose a maximum that clips 160 or a later value.

Both series have the same unit, so keep them on one axis. For a genuinely different unit, supported line/area/column charts offer Customize > Series > Apply to > Axis > Right axis. A second axis is not needed to make this fixture appear more dramatic.

The labels covered here are axis titles, month labels and legend text. Creating point-value data labels is not established by the evidence available for this guide; that optional workflow is deliberately not prescribed. Existing movable chart labels can be repositioned, and Customize > Chart style > Reset layout restores their layout.

Add a trendline and check an edit

Open Customize > Series, select Orders under Apply to, and enable Trendline. Choose Linear. With only three observations, treat the line as a descriptive aid, not a forecast. The original counts total 375; the middle observation is highest, although the fitted direction is upward overall.

Change B4 from 125 to 175. March must now be the highest Orders point and the total is 425. Restore B4 to 125 for the final saved chart. Reopen after saving and verify both series, titles and the Orders trendline.

Troubleshooting and recovery

If a point is missing, check numeric input and range boundaries first. If Trendline is unavailable, the selected chart/data combination is unsupported; do not substitute a decorative line. If a manually set axis clips an edit, revise its bounds. On a duplicate tab, remove the chart to rehearse recovery by rebuilding it from A1:C4; preserve the intact final chart.

For source-row selection rather than chart appearance, see sorting and filtering data.

Official references

Documentation basis: first-party extracted snapshots retrieved 20 October 2026. The fixture expectations were checked independently; no native Google Sheets session, account action, screenshot or export was executed for this article.