Excel Waterfall Chart Axis Text Direction Explained

To change the direction of axis text in an Excel waterfall chart, select the axis labels, open Format Axis, then go to Text Options > Text Box and choose a setting under Text direction. You can keep labels horizontal, rotate them 90 or 270 degrees, or stack the characters; the change affects how labels display, not the chart data.

What axis text direction controls

A waterfall chart shows how a starting value changes through a series of positive and negative amounts before reaching an ending value. Its horizontal category axis names the steps, such as Starting balance, Sales, Costs, and Ending balance. The vertical value axis shows the numerical scale. Text direction controls the orientation of the labels on the axis you select; it does not rotate the bars, change the order of categories, or alter any calculations.

Most questions about text direction concern the horizontal category labels, because long descriptions can collide when many steps are close together. The vertical value-axis labels may also be turned or aligned differently, but changing their direction is a separate formatting choice. Make sure you select the labels for the axis you actually want to change.

Axis labels are also different from data labels. Axis labels identify categories or scale values along the edges of the plot area. Data labels are values printed beside or inside the floating columns. Rotating one kind does not rotate the other.

Change the direction in Excel for Windows

In Excel for Microsoft 365 on Windows, use the chart formatting pane. The chart must be selected before you can select and format one of its axes. Follow these steps:

Click the waterfall chart, then click one of the axis labels you want to reorient. For category text, click a label along the horizontal axis. For scale numbers, click a value on the vertical axis.
Right-click the selected labels and choose Format Axis. If the whole chart or a data column is selected instead, click the labels again or use the chart element selection controls to select the axis.
In the Format Axis pane, select Text Options, shown by the text-related icon, and open Text Box.
Open Text direction and choose the orientation you want. Depending on the available pane controls, you can also use Custom angle to enter an angle.
Click outside the pane and check that the labels remain readable at the chart’s final size. Repeat the steps for the other axis only if it needs a different orientation.

The command is in the axis formatting pane, not in the waterfall chart’s subtotal or total settings. If the Format Axis pane shows options for bounds, units, or tick marks, you have selected an axis; switch to Text Options to reach its text controls.

Choose horizontal, rotated, or stacked labels

Horizontal is the normal choice when category names are short and the chart has enough width. It is easiest to scan and is usually clearest in a report or presentation. For example, labels such as Plan, Sales, Returns, and Total generally do not need rotation.

Rotate all text 90 degrees turns each label so it reads vertically in one direction. Rotate all text 270 degrees turns it the opposite way. These are useful when categories are long and there is little room between columns, but vertical reading can slow down comparisons. Check the direction from the chart’s actual viewing orientation rather than choosing by name alone.

Stacked places the characters one above another instead of rotating the whole word as a unit. It is not the same as turning a label 90 degrees. A label such as Cost may appear as a narrow column of individual letters, which can be hard to read; this option is generally more suitable for very short labels or constrained layouts.

If the preset directions do not fit, try a custom angle if the control is available. A modest diagonal angle can preserve more of the word’s familiar reading direction while fitting more categories into the same width. There is no universally best angle: the font, chart size, label length, and viewing distance all matter.

Make crowded category labels easier to read

Rotation is only one way to handle crowded labels. Before turning every category vertical, consider whether the chart can be made clearer by changing its layout or wording. The goal is to let readers identify each step without losing sight of the movement between the waterfall columns.

Widen the chart. A wider chart gives labels more space and can make horizontal text practical. If the chart is embedded in a narrow cell area, moving it to a larger area may help more than changing the angle.
Shorten category names. Replace a phrase such as Regional operating expenses with a concise label such as Regional costs, if the shorter wording remains unambiguous. Put definitions or detail in a note or accompanying table.
Reduce unnecessary categories. Combine minor steps only when doing so preserves the meaning of the analysis. Do not omit important movements simply to make the labels fit.
Adjust font size carefully. A slightly smaller font can help, but text that is too small is difficult to read in a printed report or projected presentation.
Use line breaks in source labels when appropriate. A category name can be split across lines by editing the source cell and inserting a line break. On Windows, Alt+Enter inserts a line break while editing a cell; on Mac, the keyboard combination can vary by Excel version and keyboard, so use the cell-editing shortcut shown for that setup. Check the chart afterward, since line breaks can make labels taller.

These changes affect the chart’s presentation, not the underlying waterfall calculations. If the chart is linked to a regularly refreshed table, keep any shorter display wording consistent so later updates do not reintroduce unwieldy labels.

Category-axis text versus value-axis text

In a standard waterfall chart, the category axis runs along the bottom and lists the steps. This is the axis most likely to need rotated text. The value axis usually runs vertically and displays numbers such as 0, 500, and 1,000. Its labels may need more room if the numbers are wide or if the chart is narrow, but rotating them can make the scale harder to interpret.

To format either axis, select its own labels before opening Format Axis. Selecting the chart title, legend, data series, or a column opens different formatting options. If you change the horizontal text and see no effect on the vertical numbers, that is expected: Excel formats each axis separately.

A waterfall chart can also include labels attached to individual columns, for example amounts such as +250 or −80. Those are data labels rather than axis text. If those values overlap, select the data labels and format or reposition them separately; the axis Text direction setting will not solve that problem.

Waterfall-specific choices that affect readability

Waterfall charts often have more categories than a simple column chart because each intermediate change gets its own step. They may also include special total columns that return to the baseline. For instance, a chart might show Opening cash, Customer receipts, Payroll, Rent, Other costs, and Closing cash. The labels for the starting and ending amounts can be longer or more important than the labels for the intermediate movements.

Keep the category wording in the same order as the data. Rotating labels does not reorder them, and it does not tell Excel that a column should be treated as a total. If a total column is not displayed as intended, use the waterfall chart’s total-column setting rather than attempting to fix it with axis text formatting. That setting is separate from text direction.

When comparing two waterfall charts, use consistent label orientation, font size, and wording where possible. If one chart uses horizontal labels and the other uses vertical labels, readers may have to adjust their scanning pattern. Consistency matters particularly when the charts share a page or dashboard, though each chart still needs enough space to remain legible.

Windows, Mac, and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. In Excel for Mac, select the axis labels and open Format Axis; the formatting pane and its icons can look different, but axis text settings are found under the text options for the selected axis. Menu placement and available controls can vary somewhat by release. If you cannot find Text direction, confirm that the axis rather than the chart area or data series is selected.

Excel for the web has fewer chart-formatting controls than the desktop applications, and the exact options available can depend on the feature and current web version. If the web interface does not offer the needed axis text direction or custom angle, open the workbook in desktop Excel, apply the formatting, and save it. The formatting can then be viewed in the workbook, although rendering may differ slightly between applications.

Common problems and fixes

The text direction control is missing. Re-select the axis labels and verify that the Format Axis pane is open. If the pane is formatting a chart area, plot area, or series, its controls will be different. On a chart with closely spaced elements, click directly on one of the labels rather than on a column.

The labels rotate but remain clipped. Rotation changes the shape of the text but does not guarantee enough space for it. Increase chart height or width, shorten labels, reduce the font slightly, or adjust the plot area. Then inspect the chart at the size at which it will be printed or displayed.

The labels look like separate letters. The Stacked setting has been selected. Choose a rotated direction or Horizontal to display each word as a continuous label.

Only some labels seem to change. Check whether the apparent text consists of axis labels or data labels, and whether the labels belong to a secondary axis in a chart that combines chart types. Waterfall charts normally use category and value axes; formatting one does not format other chart elements.

The angle changes after editing the chart. The chart may have been resized, or label wording may have changed, leaving less room. Review the orientation and chart dimensions after updating the source data, and save the workbook after confirming the final layout.

Frequently Asked Questions

Can I make waterfall chart axis labels vertical in Excel?

Yes. Select the axis labels, open Format Axis, then choose Text Options > Text Box > Text direction and select a 90- or 270-degree rotation. Use the category axis for the labels along the bottom.

How do I rotate only the category labels?

Select the horizontal category-axis labels before opening Format Axis. Apply the direction there; do not select the vertical value-axis numbers or the chart’s data labels.

What is the difference between Stacked and Rotate 90 degrees?

Rotate 90 degrees turns each complete label as a unit. Stacked arranges characters vertically, one above another, which can make words less natural to read.

Does changing axis text direction change the waterfall values?

No. It changes the appearance of axis labels only. It does not change the source data, category order, column values, or which columns are designated as totals.

Why can’t I find Text direction in Excel for the web?

Some chart-formatting controls are limited or unavailable in Excel for the web. Open the workbook in Excel for Microsoft 365 on Windows or Mac and format the selected axis in the desktop app.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.