Microsoft Excel · Analysis and charts · Intermediate
Build a scatter or combination chart for two measures
Choose a numeric scatter plot or a category-based combination chart and check axes, units, and changed inputs.
Official documentation reviewed; synthetic fixtures checked independently; not executed in Excel · Editorial standards
Quick answer: Use a scatter chart when each observation is an x/y pair. Use a combination chart when categories such as months share two measures with different units. A line through category labels is not a substitute for a numeric x-axis.
Scope and setup
These steps target English Excel for Microsoft 365 desktop on Windows. Work in a new XLSX workbook. The examples are synthetic measurements, not evidence of a real-world relationship. Use ordinary worksheet ranges, not a PivotTable or PivotChart.
Plot unequal numeric spacing
Enter the following at A1:B4 on a sheet named Measurements:
Hours Output
1 3
2 5
4 9
- Select A1:B4.
- Choose Insert > Insert Scatter (X, Y) or Bubble Chart, then a scatter type showing markers without connecting lines.
- Select the chart. Under Chart Design > Add Chart Element > Axis Titles, add a primary horizontal title of Hours and a primary vertical title of Output units.
- Replace the chart title with Output at three observation times. Choose a readable chart style without obscuring the markers.
The points must be (1,3), (2,5), and (4,9). The horizontal distance from 2 to 4 must be twice the distance from 1 to 2. That spacing is the central check: a category chart can draw three equally spaced positions even though the measured intervals differ.
Change A4 from 4 to 5 while keeping B4 at 9. The last marker should move right, not upward. Then change B4 to 11: it should move upward at the same x-coordinate. This separates correct x/y mapping from a chart that merely looks plausible. Restore A4=4 and B4=9 if keeping the original example.
Compare two measures by month
On a second sheet, enter this block at A1:C4:
Month Units Defect rate
Jan 10 0.10
Feb 20 0.20
Mar 30 0.15
Format C2:C4 as percentages. The numeric values remain 0.10, 0.20, and 0.15, not 10, 20, and 15.
- Select A1:C4 and insert a two-dimensional column chart.
- Select the Defect rate series, rather than the whole chart, and choose Chart Design > Change Chart Type. Change that series to a two-dimensional line while retaining columns for Units.
- With Defect rate selected, choose Format > Current Selection > Format Selection. Under Series Options, select Secondary Axis.
- Add axis titles that state Units and Defect rate (%). Label the chart Monthly volume and defect rate, and keep both series names in the legend.
The largest column belongs to March, while the highest rate belongs to February. These are different statements. The two axes have different units and scales, so the point where a line crosses a column has no special numerical meaning. Do not adjust the axes to manufacture an apparent relationship.
Validate and preserve
Change March’s rate to 0.25. Its line point becomes the highest; its column must remain 30. Save, close, and reopen the XLSX, then check both axis titles and the updated value. The source cells should remain available for readers who need precise numbers.
If the scatter points are equally spaced, inspect the chart type and x values. If the percentage line is compressed against zero, check its assigned axis and number format. If 15 displays as 1500%, correct the underlying value rather than hiding the error with formatting. For numeric input checks, see COUNT.