Chart & Visualization Issues

How to Align Scatter Points with Column Charts in Excel

Maira Mehtab Sep 27, 2026 869 views

Question details

The user needs to correctly align scatter plot points over a stacked or clustered column chart so they appear in the proper position rather than on the wrong side.

Product: Excel
Device & OS: not provided
Scenario: Creating a combination chart that uses both column and scatter plot types, where the data points must perfectly overlap or align.
Observed behavior: The scatter points appear misaligned or on the wrong side of the column chart because the x-values are stored as text or the horizontal axes are using mismatched scales.

Before you start

Verify that your scatter plot data uses proper numeric x-values rather than text, and ensure both data series are already added to your combination chart before attempting to synchronize the axes.

Solution 1Recommended

Convert X-Values and Synchronize Secondary Axes

Correct the data format and manually match the primary and secondary horizontal axis scales to force the scatter points into correct alignment with the columns.

Convert x-values to numbers

Select the cells containing the x-values for your scatter chart. Change their format from text to numbers, ensuring there are no hidden spaces or text formatting applied to the data.

Add a secondary horizontal axis

Select your chart, navigate to 'Chart Elements' (the plus icon next to the chart), expand the 'Axes' menu, and check the box for 'Secondary Horizontal' to display the top axis.

Match axis scale bounds

Double-click the new secondary horizontal axis to open the Format Axis pane. Set its Minimum and Maximum bounds to exactly match the values of your primary horizontal axis.

Reverse value order (if necessary)

If your scatter points are appearing mirrored on the wrong side of the chart, check the 'Values in reverse order' box under Axis Options in the Format Axis pane.

Hide the secondary axis

In the Format Axis pane for the secondary horizontal axis, go to 'Number', select 'Custom', and enter ';;;' as the format code. This hides the labels while keeping the scale active. Finally, delete the secondary vertical (Y) axis if it is not needed.

Chart Expansion: This method works regardless of the size of your dataset and can successfully align charts containing more than five categories (e.g., job grades), as long as the axis scales are perfectly synchronized.

Create Complex Charts Easily

Build and Align Combo Charts in WPS Spreadsheet

WPS Spreadsheet provides intuitive charting tools that make it incredibly easy to combine column charts and scatter plots. With streamlined axis management, you can quickly align your data points without dealing with hidden formatting issues.

1. Insert a Combo Chart: Select your dataset, go to the Insert tab, and choose Combo Chart. Assign the columns to the primary axis and the scatter points to the secondary axis.
2. Format Axis Bounds: Double-click the secondary horizontal axis to open the right-side formatting panel, and manually set the Min/Max values to match the primary axis.
3. Apply Custom Formatting: Under the Number formatting section in the panel, type ';;;' to effortlessly hide the secondary axis labels while keeping your data perfectly aligned.

Easily add and synchronize secondary horizontal and vertical axesSeamlessly fully compatible with Microsoft Excel chart formats (.xlsx)Intuitive formatting pane for precise scale and layout adjustmentsFree, lightweight, and efficient tool for advanced data visualization

microsoft office alternative - wps office

Frequently Asked Questions

Why are my scatter points completely separated from my column chart?

This happens when the scatter plot and column chart are reading from two different horizontal axes that have mismatched scales. It also occurs if your scatter plot's x-values are accidentally formatted as text instead of numbers, preventing the chart from placing them correctly on a mathematical scale.

How do I hide an axis label without deleting the axis itself?

You can hide axis labels by applying a custom number format. Right-click the axis, select Format Axis, navigate to the Number section, choose Custom, and input the code ';;;'. This makes the text invisible while keeping the structural scaling of the axis intact.

Can I add more data categories to this combo chart later?

Yes. The alignment trick scales to any number of categories or data points. If you add more rows, just make sure to update both the primary and secondary horizontal axis bounds so they continue to match each other.

What should I do if my points are showing up perfectly backwards?

If your scatter points align but appear mirrored, you need to reverse the axis. Double-click the secondary horizontal axis to open the Format Axis pane, and check the option labeled 'Values in reverse order'.

Excel & Data Problems