How to Fix Reversed Data Order in an Excel Combo Chart Secondary Axis in WPS Office
Question details
The user needs to align a line series on the secondary axis of a combo chart with a reversed horizontal date axis by setting the secondary horizontal axis to the same category direction as the primary axis.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A user has a combo chart with a horizontal date axis reversed and a line series plotted on the secondary axis; the secondary-axis line appears in the wrong chronological order.
- Observed behavior
- The secondary-axis line series is ordered left-to-right while the primary category/date axis is reversed right-to-left, making the combo chart inconsistent.
Make sure your combo chart is selected and that the line series on the secondary axis is visible. If the secondary horizontal axis is not shown, add it from Chart Design > Add Chart Element > Axes > Secondary Horizontal before changing its order.
Add a Secondary Horizontal Axis and Reverse Its Category Order
Use this when the secondary-axis line series is present but the secondary horizontal axis is hidden or does not match the reversed primary date axis.
The secondary horizontal axis controls the category direction for data on the secondary vertical axis. WPS Spreadsheets keeps this axis hidden by default, so you must add or select it before changing its order.
Click the combo chart in your WPS Spreadsheets worksheet to activate the Chart Tools tabs.
Go to Chart Design > Add Chart Element > Axes > Secondary Horizontal. If the axis already exists, skip this step.
Select the secondary horizontal axis on the chart, right-click it, and choose Format Axis.
In the Format Axis pane, under Axis Options, tick Categories in reverse order. The secondary-axis line series now follows the same right-to-left date order as the primary axis.
Verify the Primary Horizontal Axis Direction
Use this if you want to check that both horizontal axes use the same category direction before making changes.
Fix Combo Chart Secondary Axis Order in WPS Spreadsheets
WPS Spreadsheets gives you the same combo chart axis controls as Excel, so you can add a secondary horizontal axis and reverse its category order to match a right-to-left date axis.
- 1. Open the workbook: Open the workbook containing the combo chart in WPS Spreadsheets.
- 2. Select the chart: Click the combo chart to activate the Chart Tools contextual tabs.
- 3. Add the secondary horizontal axis: Go to Chart Design > Add Chart Element > Axes > Secondary Horizontal.
- 4. Format the axis: Select the secondary horizontal axis, right-click it, and choose Format Axis.
- 5. Reverse the category order: In Axis Options, enable Categories in reverse order, then confirm the secondary-axis line series matches the primary date axis.
Frequently Asked Questions
Why does my secondary-axis line series display left-to-right while the primary axis is right-to-left?
The secondary horizontal axis has its own category direction. Select it, open Format Axis, and enable Categories in reverse order to match the primary axis.
How do I add a secondary horizontal axis in WPS Spreadsheets?
Click the combo chart, then go to Chart Design > Add Chart Element > Axes > Secondary Horizontal.
Does reversing the secondary horizontal axis affect my primary axis?
No. It changes only the secondary axis category order. If both axes should match, enable the same Categories in reverse order setting on both.
Can I fix this in an .xlsx file opened with WPS Office?
Yes. WPS Spreadsheets supports Excel combo charts and secondary axes, so you can open an .xlsx file and apply the same axis settings.
What should I do if the secondary horizontal axis is not visible?
It is usually hidden by default. Add it first from Chart Design > Add Chart Element > Axes > Secondary Horizontal, then select and format it.
