Create and customize sparklines for row-by-row trends

Quick answer

Insert one sparkline per numeric row, then check source ranges and axis choices before comparing the miniature trends.

Before you start

Zoho Sheet web editor in an English desktop browser; rolling service, official documentation reviewed 20 October 2026. Not desktop-app or mobile instructions. Use an editable practice file containing only synthetic data. Keep the original unchanged and record the file name and storage location so that you reopen the same copy. These are documentation-based instructions and independently checked examples, not a claim of native application testing.

Create three contrasting trends

Enter A1:F4 as follows. Column F is initially empty and will contain the in-cell graphics.

Team	Week 1	Week 2	Week 3	Week 4	Trend
North	10	15	12	20
South	100	150	120	200
West	20	15	12	10

The first two rows have exactly the same proportional shape, but South’s values are ten times North’s. West falls from 20 to 10. This fixture exposes a common interpretation error: matching miniature shapes do not necessarily mean matching magnitudes.

Insert and map the graphics

1. Select B2:E2, excluding the team label and Trend destination.
2. Choose Insert → Sparkline → Create Sparkline. Set the Destination cell to F2 and create a line sparkline.
3. Repeat for B3:E3 into F3, and B4:E4 into F4. Creating them separately makes the source-to-destination relationship unambiguous; do not assume a multirow selection automatically produces your intended grouping.
4. Check each source range through Insert → Sparkline → Edit Sparkline, or select the graphic and use its contextual Sparkline panel.
5. Use the documented type, color and axis-level customization to make a legible comparison. Keep the numeric table visible so readers can recover exact amounts.

Line, column and win-loss sparklines serve different purposes. A line suits this ordered four-week trend. A column version emphasizes individual week heights. Win-loss emphasizes outcomes rather than magnitude and is not a good substitute for showing these workload quantities.

Check the interpretation

The final point for North should represent 20, South 200 and West 10. North rises overall, with a dip in week 3; South has the same pattern at a different scale; West declines throughout. If North and South look identical, check whether axes are scaled separately before claiming equal performance.

The documentation establishes that axis levels are customizable but does not enumerate every currently deployed axis control. If the panel permits a shared scale, apply it consistently and check South remains visibly larger. If it does not, label the graphics as independently scaled trends and avoid using their heights to compare teams. Do not silently replace this with Excel-specific sparkline controls.

Edit and verify

Change E2 from 20 to 5. North’s last point should now be its lowest, and its overall trend should end below the starting 10. South and West must not change. If all three change, inspect their sources for an accidental repeated reference to row 2. Restore E2 to 20 after the test.

Blank or text cells are a separate acceptance case. Do not infer that they mean zero. Keep this example entirely numeric; if your real data contain gaps, test one gap in a copy and explain how the chosen display treats it.

Maintain the saved report

When deleting a sparkline, the contextual panel distinguishes the selected sparkline from its whole group. Read that choice before confirming so you do not remove every team’s graphic. The numbers should remain available even if the miniature graph is deleted.

Reopen the workbook and check F2:F4 plus their source values. For a PDF or workbook export, inspect the actual exported file: a sparkline’s presence and readability in the cloud editor do not establish how another application renders it.

Related tutorial

Continue with create chart.

Official sources

Documentation reviewed 20 October 2026.

• Create and edit sparklines