Make Both X-Axis Labels Horizontal in an Excel Gantt Chart
Question details
Make both labels on the X-axis of a combined scatter Gantt chart horizontal.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants consistent text orientation for two labels in an Excel Gantt chart.
- Observed behavior
- One label is rotated 90 degrees, while the other is horizontal.
Click each label in the chart to identify whether it belongs to an axis, a data label, or a text box. Labels from different chart elements must be formatted separately.
Set the X-axis label orientation to horizontal
Use this method when the rotated text is an axis label.
Click the Gantt chart, then click the rotated X-axis labels to select the axis.
Right-click the selected labels and choose Format Axis.
In the Format Axis pane, open Text Options and Text Box. Set Text direction to Horizontal or Custom angle to 0 degrees.
Click the other label. If it belongs to a separate axis, open Format Axis for that axis and apply the same setting.

Adjust data labels or linked text boxes separately
Use this method if a label is not controlled by the axis formatting settings.
Work with Gantt Chart Workbooks in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easier to move existing workbooks to WPS. Check complex charts after opening them, as rendering may differ from Excel.

Frequently Asked Questions
Why did changing the axis orientation affect only one label?
The labels may belong to different chart elements or separate axes. Select the unchanged label and open its corresponding Format Axis, Format Data Labels, or Format Shape pane.
Where can I set an Excel chart label's angle to zero?
Right-click the label or its axis, open the appropriate format pane, and look under Text Options and Text Box for Custom angle. Set it to 0 degrees if that option is available.
What if I cannot tell whether the text is an axis label or a text box?
Click the text and check the options shown when you right-click it. Format Axis indicates an axis; Format Data Labels indicates a data label; Format Shape may indicate a text box. A screenshot or sample workbook can also help identify the element.




