An in-cell chart lets the maintenance team see the shape of each row without widening the report. Enter Repairs in A2 and Checks in A3, with Jan–Mar in B1:D1. The readings are 6, 12, 9 and 5, 7, 10.

Place a line at the end of each row

In Ulet choose Insert → Sparklines → Line. Open an existing XLSX for this exercise. Enter B2:D3 as the data range and E2:E3 as the location range. Confirm and give E enough width to see the three positions.

The two data rows and the two output cells are marked in different colors.

Illustrated selection. B2:D3 supplies the readings and E2:E3 holds the charts.

Check the peak against the values

Repairs should peak in the middle and Checks at the right. If both shapes match, recheck the source rows and look for a hidden or blank month. Use the adjacent cells for exact counts or a full chart with a shared scale to compare heights.

The Repairs line peaks in February while the Checks line peaks in March.

Illustrated check. Read the numbers in the table when you need exact counts.

Microsoft Excel instructions