How to Fix Primary and Secondary Axes Not the Same Size in Excel Charts

Please clearly explain how Microsoft 365 and Office treats categorical versus value-based data structures in charting. Use clear logic so that users creating reports For business understand why their data markers are shifting out of place

Understanding Why Primary and Secondary Axes Not the Same Size

The workflow begins at a specific Excel entry point: Please write a concise explanation of why spreadsheet software sometimes mismatches axes in combo charts. Mention that when plotting two different sets of data (e.g., daily rainfall and streamflow) over a specific time period, mixing chart types like Scatter (which uses a value-based X-axis) and Line (which uses a category-based X-axis) forces the software

Understanding Why Primary and Secondary Axes Not the Same Size

This Primary and Secondary Axes Not the Same Size in Excel Charts procedure uses the controls available in Format Axis Pane; complete each action before moving to the next.

1. Please write a concise explanation of why spreadsheet software sometimes mismatches axes in combo charts. Mention that when plotting two different sets of data (e.g., daily rainfall and streamflow) over a specific time period, mixing chart types like Scatter (which uses a value-based X-axis) and Line (which uses a category-based X-axis) forces the software
2. Change the series which is currently a scatter chart to a line chart
3. Remove the lines that appear between the points using No Line
4. And change the x-axis format to Date
5. And if it's still not lining up properly double check that both series are using the same X values
6. I can't seem to use the MS shared link

How to Verify the Excel Result

Run the final check exactly as described: I can't seem to use the MS shared link If it fails, return to Format Axis Pane and confirm that Please write a concise explanation of why was applied to the intended item.

Complete This Local Workflow with WPS Spreadsheets

Use Word, Excel, and PPT for FREE

Free Download

For Primary and Secondary Axes Not the Same Size in Excel Charts, WPS Office provides a free, lightweight route for this local Excel task. WPS Spreadsheets supports common Microsoft Office files in a familiar interface and adds PDF tools and WPS AI for drafting, summarizing, formulas, and routine document work.

1. Open the workbook in WPS Spreadsheets and select the chart.
2. Open Chart Tools, choose the secondary axis, and select Format Axis.
3. Set matching minimum, maximum, and major-unit values for both vertical axes.
4. Compare the plot areas and save the XLSX file after both axes align.

Excel FAQs About Primary and Secondary Axes Not the Same Size in Excel Charts

Why are my primary and secondary axes not the same size even after manually matching the bounds?

This occurs when the software treats one X-axis as a text/category list and the other as a continuous numerical/date scale. To fix this, ensure both axes are explicitly set to "Date axis" in the Format Axis pane, and verify your source data columns do not contain hidden text strings or blank spaces.

How do I remove the connecting lines after changing my scatter plot to a line chart?

Right-click your new line data series, select Format Data Series, click on the Fill & Line icon, and choose "No Line." Your data markers will remain visible just like a scatter plot, but the chart engine will enforce the correct axis alignment.

Can I fix this axis scale mismatch using the spreadsheet app on Android?

While mobile apps allow basic chart resizing, deep structural settings like forcing a "Date axis" type are limited. Apply the detailed axis formatting steps on your desktop; the corrected graph layout will then display and sync perfectly on your mobile device.

Why should I consider WPS Office for resolving chart issues instead of other suites?

WPS Spreadsheet natively supports all major complex chart types and secondary axes with highly intuitive formatting sidebars. It reads and saves standard spreadsheet formats perfectly, ensuring your business data stays compatible without the burden of expensive monthly subscriptions.