Charts & pivot tables
Build, format and fix charts and pivot tables.
- Excel Waterfall Chart Total Column: How to Add OneTo make a column a total in an Excel waterfall chart, select that individual column, right-click it, and choose Set as Total.…
- Excel Waterfall Chart: Show a Total at the EndTo show a final total in an Excel waterfall chart, select the last bar, right-click it, and choose Set as Total. The…
- Excel Waterfall Chart Total Bar: Set It CorrectlyTo make a bar in an Excel waterfall chart represent a total, right-click that data point and choose Set as Total. Excel…
- Excel Waterfall Chart Subtotals: How to Set ThemTo show a subtotal in an Excel waterfall chart, select its bar, right-click, and choose Set as Total. Enter the subtotal as…
- Excel Waterfall Chart Split Bar: How to Show ComponentsExcel’s built-in Waterfall chart cannot split one bar into stacked segments. To show what makes up a change, either add separate, consecutive…
- Excel Waterfall Charts: How Stacked Bars Build the BridgeYes—an Excel waterfall chart uses columns that appear to float or stack between levels, showing how positive and negative changes move a…
- Excel Waterfall Chart Set as Total: Steps and FixesTo set a column as a total in an Excel waterfall chart, select that individual column, right-click it, and choose Set as…
- Excel Waterfall Chart Setup: A Practical Step-by-Step GuideTo set up a waterfall chart in Excel for Microsoft 365 on Windows, put each step and its change in adjacent columns,…
- Excel Waterfall Charts: Show Multiple Data Sets?Excel’s built-in Waterfall chart is designed to show one running sequence of values at a time, not several data sets as parallel…
- Excel Waterfall Chart: Rotate Axis Labels in 5 StepsTo rotate labels in an Excel waterfall chart in Microsoft 365 for Windows, select the chart’s axis labels, right-click and choose Format…
- Excel Waterfall Charts with Multiple Series ExplainedNo—not as separate, independent series in Excel’s built-in Waterfall chart. In Microsoft 365 for Windows, a native waterfall chart represents one sequence…
- Excel Waterfall Chart: Remove Connector LinesTo remove connector lines from a waterfall chart in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design…
- Excel Waterfall Chart Not Showing Total? Fix ItIf an Excel waterfall chart is not showing a total, select the bar that should represent the total, right-click it, and choose…
- Excel Waterfall Chart Inputs and SetupExcel waterfall chart inputs are a list of categories and one matching list of numeric changes or balances: put the labels in…
- Excel Waterfall Chart: How to Set the Last Bar as a TotalTo make the last bar in an Excel waterfall chart show the final total, right-click that bar and choose Set as Total.…
- Excel Waterfall Chart: Make the Last Column a TotalTo make the last column in an Excel waterfall chart a total, select the chart, click the final column twice to select…
- Excel Waterfall Chart Help: Build, Format, and Fix OneTo create a waterfall chart in Excel for Microsoft 365 on Windows, place each step of your change in one column, select…
- Excel Waterfall Chart: How to Show the Final TotalTo show a final total in an Excel waterfall chart, select the bar for that value, right-click it, and choose Set as…
- Excel Waterfall Chart Connector Lines: How to FormatIn Excel for Microsoft 365 on Windows, select the waterfall chart’s data series, open Format Data Series, expand Series Options, and select…
- Excel Waterfall Chart Final Column: Set It as a TotalIn Excel for Microsoft 365, select the chart’s final data point, right-click it, and choose Set as Total. This makes the last…
- Excel Waterfall Chart End Value: Set the Final TotalTo make the last bar in an Excel waterfall chart show the ending balance, right-click that bar and choose Set as Total.…
- Excel Waterfall Chart: Can Colors Follow Values?Excel’s built-in waterfall chart can color increases, decreases, and totals differently, but it does not automatically apply colors from custom value rules…
- Excel Waterfall Chart Data Labels: Add and Format ThemTo add labels to an Excel waterfall chart in Microsoft 365 for Windows, select the chart, then choose Chart Design > Add…
- Excel Waterfall Chart Data Layout: How to Set It UpFor an Excel waterfall chart, arrange your source data in two columns: a category label and the amount of the increase or…
- Excel Waterfall Chart Axis Text Direction ExplainedTo change the direction of axis text in an Excel waterfall chart, select the axis labels, open Format Axis, then go to…
- Excel Waterfall Chart: Change Colors and Format BarsTo change colors in an Excel waterfall chart, select the chart and choose Chart Design > Change Colors to apply a different…
- Excel Waterfall Chart: How to Change the Legend TextIn Excel for Microsoft 365 on Windows, you generally cannot rename the built-in Increase, Decrease, and Total legend entries in a waterfall…
- Excel Waterfall Chart: Can You Add an Axis Break?No: Microsoft Excel for Microsoft 365 does not provide a built-in axis-break control for a native waterfall chart. You can format the…
- Excel Vertical Line Chart: How to Create and Format OneYes—you can add a vertical reference line to an Excel chart, most reliably by adding a two-point XY scatter series whose points…
- Excel Update Pivot Chart: Steps and FixesTo update an Excel PivotChart in Microsoft 365 for Windows, click its associated PivotTable and choose PivotTable Analyze > Refresh, or select…