Fix an Excel Chart That Uses the First Column on the Vertical Axis
Question details
The user needs to correct the data orientation and category labels in an Excel chart.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A chart created from a table should use the first column as category labels and the remaining columns as numeric series.
- Observed behavior
- Excel places the first column on the vertical axis or displays an unexpected chart layout.
Check the chart type and the source table. For a typical column chart, place category labels in the first column, series headers in the first row, and numeric values in the remaining columns.
Correct the Excel chart orientation and category labels
Use this method when Excel has interpreted the source rows, columns, or labels incorrectly.
Select the chart, open Chart Design, and choose Switch Row/Column. Check whether the series and categories now match the source table.
With the chart selected, choose Chart Design > Select Data. Verify that the Chart data range includes the category labels, series headers, and numeric values.
In the Select Data Source dialog, review the entries under Legend Entries (Series). Select a series and choose Edit to correct its name or values.
Under Horizontal (Category) Axis Labels, choose Edit and select the cells containing the first-column category labels. Confirm with OK.

Adjust chart data and labels in WPS Spreadsheet
Open your workbook in WPS Spreadsheet, check the chart data range, and adjust its series and category labels to create the intended layout.
- 1. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Inspect the chart data: Click the chart, then open Chart Tools and choose Select Data to review the source range and series.
- 3. Adjust the orientation: Use Switch Row/Column in the chart tools or data-selection dialog if the series and categories are reversed.
- 4. Check labels and save: In Select Data, check the category-label range and series values, then use File > Save As to save the workbook in XLSX format.

Frequently Asked Questions
Why are my category labels on the vertical axis?
If you selected a horizontal bar chart, that placement is normal. To put categories along the bottom, select the chart and choose Chart Design > Change Chart Type > Column.
How do I change which cells supply the chart labels?
Select the chart and choose Chart Design > Select Data. Under Horizontal (Category) Axis Labels, select Edit and choose the label cells.
What does Switch Row/Column do?
Chart Design > Switch Row/Column changes whether Excel treats rows or columns as data series. Check the resulting legend and labels to see whether the orientation is correct.
Why can't I set category labels on my scatter chart?
An XY scatter chart plots numeric X and Y values rather than using a category-label axis. Use Chart Design > Select Data to edit the X and Y ranges, or change to a column chart if you need category labels.




