How to Rotate a Waterfall Chart in Excel: Axis Options

To change the way a waterfall chart reads in Excel, format its category axis: reverse the category order or angle the category labels. Excel does not provide a horizontal version of its built-in waterfall chart or a direct command to turn the chart 90 degrees. The steps below show what you can change, how to do it in Microsoft 365 for Windows, and what to use when you need a horizontal layout.

What You’ll Need

Excel for Microsoft 365 on Windows, with a workbook containing a waterfall chart. The built-in chart type is also available in recent Excel versions that support waterfall charts.
A chart with categories and values arranged in a simple table. For example, categories such as Starting balance, Sales, Costs, and Ending balance in one column, with their values in the next.
A clear idea of what you mean by rotate: changing the order of the steps, tilting the category labels, or making the bars horizontal. These are different adjustments in Excel.

Step-by-Step

Decide which kind of rotation you need. If the categories appear in the wrong sequence, reverse their order. If long names overlap, angle the labels. If you want the bars to run from left to right instead of bottom to top, that is a horizontal layout; Excel’s native waterfall chart does not have that option. The remaining steps explain the two changes that can be made while keeping the chart a native waterfall.
Select the category axis or its labels. Click the chart once, then click the category labels along the bottom of the chart. If the chart has a title, legend, or data labels, take care to select the axis labels rather than another chart element. A selection border or handles should appear around the labels. You can also right-click a category label and choose Format Axis. On Windows, selecting the axis and pressing Ctrl+1 opens the formatting pane for the selected element.
Reverse the category order if the sequence is backwards. In the Format Axis pane, select Axis Options (the icon with bars). Under the axis options, select Categories in reverse order. The first and last categories will exchange sides, while the values and the waterfall relationships remain associated with their categories. This is useful when a chart reads in the opposite direction from the story you want to tell, but it does not turn the vertical columns into horizontal bars.
Check where the value axis crosses after reversing. Reversing categories can move the value axis to the other side of the chart, which may make the display look unexpectedly different. If that happens, select the value axis, open Format Axis, and look in Axis Options for the setting that controls where the horizontal axis crosses. Depending on the chart and Excel build, it may offer an option to cross at the maximum category. Adjust it only if the axis is now in an awkward position; the category sequence and the axis crossing are separate settings.
Angle labels to make long names easier to read. Select the category axis labels, right-click, and choose Format Axis. In the pane, open Text Options, then Text Box. Set Custom angle to a modest value such as 45 or -45 degrees, and check the chart preview. The sign determines the slant direction, so try the other sign if the labels lean the wrong way. For a vertical label appearance, use the text direction option if it is available in your pane. Avoid rotating labels so far that readers must tilt their heads to read them.
Give the labels enough space. After changing the angle, widen the chart or increase its height if labels are clipped or collide with the chart edge. Drag the chart’s sizing handles, or move it to a wider area of the worksheet. If you have many categories, shortening labels or splitting a long description over two lines can be more readable than using a steep angle. Check that the plot area still leaves enough room for the columns and any data labels.
Confirm that totals are still shown as totals. If you reversed the category order, inspect the start, intermediate changes, and ending balance. In a waterfall chart, a total is a special data point that starts from the baseline rather than continuing from the previous step. If a total is displayed as a floating increase or decrease, right-click that column and choose Set as Total. A simple check is a sequence of +500, -150, and -90, which ends at 260; the ending balance should be marked as a total if it is included as a separate point. Reversing the axis order does not itself set or repair total points.
Understand the limit if you need horizontal bars. Excel’s built-in waterfall chart plots its steps as vertical columns. There is no rotate-chart command that converts it into a horizontal waterfall while preserving the native chart type. Chart Design > Switch Row/Column, if enabled, changes how Excel reads the data; it is not a rotation control and can make the waterfall series invalid or confusing. Do not use it as a substitute for a horizontal chart.
Choose a workaround only if horizontal orientation is essential. For a report where appearance matters more than editability, copy the chart and paste it as a picture, then rotate the picture using the picture-format rotation controls. This turns it into a static image: the values and labels will not update when the source data changes. If the chart must remain live and horizontal, rebuild it using a stacked bar chart with helper values that create the floating steps. That approach takes careful setup and does not have all the behavior of a native waterfall chart, so verify every step and total against the source data.
Check the finished chart at its final size. Click outside the chart to see how it looks without selection handles. Confirm that categories appear in the intended order, labels are legible, totals are clear, and the value axis has not moved to an inconvenient side. If the chart will be printed or pasted into a presentation, review it at that size too; a label angle that looks fine on a large worksheet may be hard to read in a smaller report.

Common Mistakes

Expecting a full chart rotation. The Format Axis settings affect the order or presentation of axis labels; they do not rotate the waterfall columns. A native Excel waterfall chart remains vertical. If horizontal bars are mandatory, plan for a separate stacked-bar construction or a static rotated image.

Confusing category order with totals. Checking Categories in reverse order changes the reading order, not which columns are totals. Mark opening and ending balances as totals where appropriate, and verify the intermediate increases and decreases independently.

Using Switch Row/Column to force a horizontal chart. This command changes the interpretation of the selected data, not the orientation of the chart. It may rearrange categories or remove the intended waterfall structure. Use it only when the source table is genuinely organized in the wrong direction and confirm the result carefully.

Rotating labels too far. A 90-degree label can technically fit in less horizontal space, but it often takes longer to read and can consume vertical room. Try shorter wording, a wider chart, or a smaller angle before using vertical text.

Editing the wrong axis. A waterfall chart has a category axis and a value axis. Reversing categories or angling category names requires selecting the category axis. If the Format Axis pane shows number bounds or units instead, you likely selected the value axis; close the pane and select the labels along the bottom instead.

Tips

Use reverse order when the data itself is correct but the chart should read from the opposite end. If the source table is already in the desired order, changing the worksheet data may be unnecessary.
Keep category names short and consistent. For example, use Costs rather than a long sentence, and put detail in a note or a nearby table.
Choose a label angle that matches the chart’s available width. A slight slant is usually easier to scan than steeply angled or vertical text.
For a presentation or printed report, use a larger chart area and check that axis labels, column labels, and the legend do not overlap.
On Excel for Mac, select the axis and use the contextual formatting pane, or control-click the axis and choose its format option. The pane layout and some labels can differ from Windows; look for axis options to reverse categories and text options to adjust label direction or angle. Excel for the web may expose fewer detailed formatting controls, so use the desktop app if you cannot find the angle setting.

Troubleshooting

I cannot find Categories in reverse order. Make sure the category axis itself is selected, not the columns, chart area, or value axis. Right-click a category name along the bottom and choose Format Axis. Expand Axis Options in the pane. If the chart is not a native waterfall or the selected element is a different axis, the available controls will differ.

The labels did not rotate. Confirm that the category labels are selected before opening Text Options. In Format Axis, open the Text Box controls and look for Custom angle or the text direction control. Some Excel releases arrange these controls differently. If the option is missing in Excel for the web, open the workbook in desktop Excel. Widening the chart or shortening labels is a practical fallback.

The value axis moved after I reversed the categories. This is an axis-crossing effect, not a broken waterfall. Select the value axis and adjust its crossing option in Axis Options if you want it on the other side. If you cannot find a crossing control for the selected axis, reselect the value axis rather than the category axis.

The chart looks wrong after Switch Row/Column. Use Ctrl+Z on Windows to undo the change, or use the Undo button. Then check the source data layout and select only the category and value columns when creating or editing the chart. Switch Row/Column is not a rotation feature; if the command is unavailable, that can also be a limitation of the selected chart type.

A total floats instead of starting from zero. Right-click the relevant column and choose Set as Total. Repeat for each beginning or ending balance that should be anchored to the baseline. Check the arithmetic against the source values; for example, 500 minus 150 minus 90 equals 260. If the displayed result differs, check for omitted or incorrectly signed input values.

Labels overlap or are cut off. Make the chart wider or taller, reduce the label angle, shorten the category text, or enlarge the space below the plot area. If you rotate labels and then resize the chart, inspect them again because Excel may adjust the plot area automatically.

Frequently Asked Questions

Can I rotate a waterfall chart 90 degrees in Excel?
No. Excel does not provide a native command to rotate a built-in waterfall chart into a horizontal chart. You can angle its axis labels, reverse category order, or create a horizontal-looking workaround with a stacked bar chart.

How do I rotate only the labels, not the columns?
Select the category axis labels, open Format Axis, then use Text Options > Text Box to set a custom angle or text direction. This changes label presentation but leaves the waterfall columns vertical.

How can I make the waterfall chart read from right to left?
Select the category axis, open Format Axis > Axis Options, and select Categories in reverse order. Check the position of the value axis afterward, as it may move when the categories reverse.

Does Switch Row/Column rotate a waterfall chart?
No. It changes how Excel interprets the data arrangement. It does not change vertical waterfall columns into horizontal bars, and it may disrupt the chart if the data is no longer arranged as categories and values.

Can I rotate a waterfall chart in Excel for Mac?
You can format its category order and label direction in the Mac desktop app, although the pane layout can differ from Windows. A native horizontal waterfall option is not available there either.

Will a rotated chart picture update when my data changes?
No. A chart pasted as a picture is static. It will not reflect source-data changes, so update the original chart and create a new picture whenever the numbers change.

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.