Chart & Visualization Issues

Make Both X-Axis Labels Horizontal in an Excel Gantt Chart

John WilsonJohn Wilson Nov 20, 2026 870 views

Question details

Make both labels on the X-axis of a combined scatter Gantt chart horizontal.

Make Both X-Axis Labels Horizontal in an Excel Gantt Chart
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.
Before you start

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.

Solution 1Recommended

Set the X-axis label orientation to horizontal

Use this method when the rotated text is an axis label.

1
Select the axis labels

Click the Gantt chart, then click the rotated X-axis labels to select the axis.

2
Open axis formatting

Right-click the selected labels and choose Format Axis.

3
Change the text orientation

In the Format Axis pane, open Text Options and Text Box. Set Text direction to Horizontal or Custom angle to 0 degrees.

4
Check the other label

Click the other label. If it belongs to a separate axis, open Format Axis for that axis and apply the same setting.

Set the X-axis label orientation to horizontal
Different chart elements: If changing the axis does not affect a label, the label may be a data label or a separate text box.
Free Microsoft Office alternative

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.

Open Excel XLS and XLSX workbooks in WPS Spreadsheets.Work with spreadsheet charts and Gantt chart data.Use a familiar interface to ease migration from Microsoft Office.Access a free, lightweight office suite.
microsoft office alternative - wps office

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.