Chart & Visualization Issues

How to Align Scatter Points and Columns in an Excel Combo Chart

Kushani Nimanthika Oct 21, 2026 868 views

Question details

The user needs to properly align XY scatter data points with column chart series within a combination chart.

How to Align Scatter Points and Columns in an Excel Combo Chart

Product: Excel
Device & OS: not provided
Scenario: Creating a combo chart containing both column and XY scatter series where the data points must align exactly with the columns on the X-axis.
Observed behavior: The XY scatter points and column series are visually misaligned because they rely on different horizontal-axis scale calculations and category mappings.

Before you start

Ensure that the X-values for both your scatter series and your column series are based on the same dataset, and check that neither contains hidden blank rows that could shift categories.

Solution 1Recommended

Match Primary and Secondary Axis Bounds

The most common cause of misalignment is mismatched minimum and maximum scale bounds between the primary and secondary horizontal axes.

In a combo chart, column series often map to text-based categories (which Excel treats as 1, 2, 3...) on the primary axis, while the scatter series uses its own numerical scale on the secondary axis. Synchronizing these scales forces both series to align.

Identify Primary Axis Bounds

Select your combo chart and double-click the primary horizontal axis (bottom) to open the Format Axis pane. Note the numbers under Minimum and Maximum in the Axis Options.

Reveal the Secondary Horizontal Axis

If your secondary horizontal axis (top) is hidden, click the chart, select the 'Chart Elements' icon (the plus sign), hover over 'Axes', and check 'Secondary Horizontal'.

Match the Bounds

Double-click the newly revealed secondary horizontal axis to open its Format Axis pane. Manually type in the exact Minimum and Maximum values you recorded from the primary axis.

Match Major Units

While in the secondary axis options, ensure the 'Major' unit also matches the primary axis so gridlines and points align perfectly.

Alignment Achieved: Ensuring both axes share the exact same scale instantly snaps your scatter points into alignment with the center of the corresponding columns.

Solution 2

Use a Helper Column for Precise X-Values

Use calculated X-values to forcefully position scatter data points for exact control, especially useful for clustered columns.

Create Beautiful Combo Charts in WPS

Align and Customize Combo Charts Easily in WPS Office

WPS Spreadsheet offers an intuitive Chart interface that makes building combo charts and managing secondary axes incredibly easy. You can align complex datasets with precision while maintaining full compatibility with Microsoft Excel.

1. Select Your Data: Highlight the entire data range you want to visualize in WPS Spreadsheet.
2. Insert a Combo Chart: Navigate to the Insert tab, click the Chart icon, and select 'Combo' from the chart types list.
3. Configure Series and Axes: In the configuration window, set your desired series to 'Scatter' and check the 'Secondary Axis' box for it, leaving the other series as 'Column'.
4. Sync Axis Scales: Double-click the axes in your newly generated chart to easily sync their minimum and maximum bounds in the right-hand format pane.

Easily create and manage complex combo charts with built-in visualization tools.Seamlessly match primary and secondary axes using an intuitive properties pane.100% compatible with Microsoft Excel (.xlsx) chart formats and data.Free, lightweight, and fast spreadsheet application for all your data needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my scatter points appear between columns instead of on them?

This happens because column charts use text-based categories (positioned implicitly at whole numbers 1, 2, 3...), while scatter charts plot on a continuous numerical scale. Matching the secondary axis bounds to the primary axis resolves this spacing issue.

How do I display the secondary horizontal axis if it's hidden?

Click on your chart to reveal chart tools, go to the Chart Elements menu (the plus icon in the upper right corner of the chart), hover over 'Axes', and check the box for 'Secondary Horizontal Axis'.

Can I align multiple scatter series to different column clusters?

Yes, by using helper columns to assign precise X-coordinate decimals (e.g., 1.15 for the first column in a cluster, 1.85 for the second) you can position scatter points exactly over specific clustered columns rather than the center of the category.

Excel & Data Problems