Chart & Visualization Issues

Fix an Excel Chart That Uses the First Column on the Vertical Axis

Maira MehtabMaira Mehtab Nov 18, 2026 869 views

Question details

The user needs to correct the data orientation and category labels in an Excel chart.

Fix an Excel Chart That Uses the First Column on the Vertical Axis
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.
Before you start

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.

Solution 1Recommended

Correct the Excel chart orientation and category labels

Use this method when Excel has interpreted the source rows, columns, or labels incorrectly.

1
Switch the data orientation

Select the chart, open Chart Design, and choose Switch Row/Column. Check whether the series and categories now match the source table.

2
Check the chart data range

With the chart selected, choose Chart Design > Select Data. Verify that the Chart data range includes the category labels, series headers, and numeric values.

3
Verify the series

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.

4
Set category labels

Under Horizontal (Category) Axis Labels, choose Edit and select the cells containing the first-column category labels. Confirm with OK.

Correct the Excel chart orientation and category labels
Check the chart type: A horizontal bar chart normally places category labels on the vertical axis. An XY scatter chart uses numeric X and Y values rather than a category-label axis. If you need categories along the bottom, select the chart and choose Chart Design > Change Chart Type > Column.
Work with charts in WPS Office

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. 1. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
  2. 2. Inspect the chart data: Click the chart, then open Chart Tools and choose Select Data to review the source range and series.
  3. 3. Adjust the orientation: Use Switch Row/Column in the chart tools or data-selection dialog if the series and categories are reversed.
  4. 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.
Adjust chart data orientation and category labelsOpen and save Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with spreadsheets using a free Office suite
microsoft office alternative - wps office

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.