Fix Wrong Axis Labels and Data Orientation in an Excel Chart
Question details
The user needs to correct an Excel chart's axis labels, series names, and row or column orientation.

- 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.
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.
Correct the Excel chart's source data and orientation
Use this method to fix an existing chart without recreating it.
Click the chart to display the Chart Design tab.
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.
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.
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.
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.

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.

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.




