Chart & Visualization Issues

Fix Excel Waterfall Chart Formatting and Axis Options Unavailable

Khadija KhanKhadija Khan Oct 22, 2026 872 views

Question details

The user is unable to access specific formatting options, such as plot-area resizing and horizontal-axis text direction, when customizing waterfall charts.

Fix Excel Waterfall Chart Formatting and Axis Options Unavailable
Product
Microsoft Excel for Microsoft 365
Device & OS
not provided
Scenario
Customizing the layout, text properties, and axis alignment of a waterfall chart to fit presentation needs.
Observed behavior
Formatting features including plot-area resizing, horizontal-axis text-box settings, text direction, and alignment options are grayed out, unavailable, or blank.
Before you start

Ensure your Microsoft 365 subscription is active and that your Excel application is updated to the latest version before testing chart limitations.

Solution 1Recommended

Apply Chart Resizing Workarounds

Since Excel intentionally restricts certain text and plot-area formatting in waterfall charts, resizing the entire chart object is the best way to adjust the layout without needing disabled tools.

Microsoft Excel restricts some alignment, text-direction, and inner plot-area resizing options specifically for waterfall charts. This is an intentional design choice to maintain the structural integrity and standard appearance of the chart type.

1
Select the entire chart

Click on the outer boundary of the waterfall chart to ensure you have selected the entire chart area rather than the inner plot area.

2
Resize the chart object

Click and drag the sizing handles located on the corners or edges of the chart boundary to scale the entire chart up. This will proportionally adjust the inner elements to give your data more room.

3
Adjust font size manually

If horizontal axis text is overlapping or cut off because rotation options are disabled, go to the Home tab and manually reduce the font size to make the labels fit.

Apply Chart Resizing Workarounds
Design Limitation: The inability to rotate text or independently drag and resize the plot area in waterfall charts is expected behavior in Excel for Microsoft 365.
Free Microsoft Office alternative

Try WPS Office for Flexible Data Visualization

If you are frustrated by intentional design limitations in Microsoft Excel, consider switching to WPS Office. It provides a highly compatible, lightweight, and free alternative with robust chart customization features that feel instantly familiar.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
  2. 2. Open your Excel file: Launch WPS Spreadsheet and open your existing .xlsx file containing the chart data.
  3. 3. Customize your charts: Use the highly intuitive chart tools in WPS Office to format and adjust your data visualizations easily.
100% compatible with Microsoft Excel (.xlsx) formats and charts.Free, lightweight, and fast-loading spreadsheet application.Familiar user interface requiring zero learning curve.Rich chart formatting tools for fully customized data visualization.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I rotate the horizontal axis text in an Excel waterfall chart?

Microsoft Excel intentionally restricts text direction and alignment options on the horizontal axis of waterfall charts to maintain the default visual structure and readability standards of this specific chart type.

How can I fix overlapping text on a waterfall chart axis if I can't rotate it?

Since you cannot rotate the text, the best workarounds are to expand the overall width of the chart object, reduce the font size of the axis labels, or manually abbreviate the source data labels in your original worksheet cells.

Are there other Excel chart types with similar formatting restrictions?

Yes, several newer chart types introduced in Microsoft 365, such as Funnel, Treemap, and Sunburst charts, have similar intentional restrictions regarding plot area resizing and text rotation.

Can I manually resize the inner plot area of a waterfall chart?

No, the inner plot area of a waterfall chart is locked by default in Excel. To increase the space for the data columns, you must select the outer chart border and resize the entire chart object.