Chart & Visualization Issues

Fix Wrong Axis Labels and Data Orientation in an Excel Chart

Elise WilliamsElise Williams Nov 18, 2026 871 views

Question details

The user needs to correct an Excel chart's axis labels, series names, and row or column orientation.

Fix Wrong Axis Labels and Data Orientation in an Excel Chart
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating or editing a chart from a table with category labels and data series.
Observed behavior
The chart may plot rows instead of columns, place category labels incorrectly, or show a data series as the chart title.
Before you start

Check that the source data has one header row and a category column, with no unintended title rows inside the chart range. Identify which cells should supply the category labels and which contain the data series.

Solution 1Recommended

Correct the Excel chart's source data and orientation

Use this method to fix an existing chart without recreating it.

1
Select the chart

Click the chart to display the Chart Design tab.

2
Check the source range

Choose Chart Design > Select Data. Check the Chart data range and adjust it to include the data, category labels, and series headers while excluding any unrelated title row.

3
Switch rows and columns

If the series are still plotted in the wrong direction, choose Chart Design > Switch Row/Column, or use Switch Row/Column in the Select Data dialog.

4
Verify labels and series names

Open Chart Design > Select Data again. Under Horizontal (Category) Axis Labels, select Edit and choose the category label cells. Under Legend Entries (Series), select a series and choose Edit to check its name and values.

5
Correct the chart title

Click the chart title and type the intended title. If the chart has no title, use Chart Design > Add Chart Element > Chart Title to add one.

Correct the Excel chart's source data and orientation
Keep the series headers: Exclude an unrelated title row from the source range, but retain the header cells that should name the data series.
Free Microsoft Office alternative

Create clear spreadsheet charts with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for editing Excel-compatible spreadsheets and creating charts. Open an existing workbook to continue working in WPS; it does not change Excel's own chart settings.

Create charts from spreadsheet data and review their labels and series.Open and edit Microsoft Excel formats, including XLSX and XLS.Use a familiar spreadsheet interface for an easier move from Microsoft Office.Work with a lightweight office suite that is free to download.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel chart plotting each row as a separate series?

Excel may have interpreted the source range in the wrong direction. Select the chart and choose Chart Design > Switch Row/Column to change the orientation.

How do I change the horizontal axis labels?

Select the chart, choose Chart Design > Select Data, and select Edit under Horizontal (Category) Axis Labels. Then select the cells containing the intended labels.

Why does a series have the wrong name?

The chart may reference the wrong header cell. Go to Chart Design > Select Data, select the series under Legend Entries (Series), and choose Edit to correct its name.

Should I include the table's title in the chart data range?

Usually, exclude a separate table title row from the range. Include the header row and category column so Excel can use them for series names and axis labels.