Fix Excel Waterfall Chart Formatting and Axis Options Unavailable
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.

- 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.
Ensure your Microsoft 365 subscription is active and that your Excel application is updated to the latest version before testing chart limitations.
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.
Click on the outer boundary of the waterfall chart to ensure you have selected the entire chart area rather than the inner plot area.
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.
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.

Verify Chart Behavior in a New Workbook
Test if the formatting restriction is standard behavior or a glitch specific to your current workbook file.
Escalate to Microsoft 365 Support
If you believe the chart is malfunctioning beyond the standard documented limitations, you can open a support ticket for further investigation.
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. Download and Install: Get WPS Office for free from the official website and install it on your computer.
- 2. Open your Excel file: Launch WPS Spreadsheet and open your existing .xlsx file containing the chart data.
- 3. Customize your charts: Use the highly intuitive chart tools in WPS Office to format and adjust your data visualizations easily.

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.




