Combo chart vs waterfall: pick the right one
A combo chart puts two series on related scales, like monthly Revenue bars with a Profit line on top. A waterfall shows a running total that rises and falls, perfect for bridging Revenue to Profit through Costs. Use the combo when you compare magnitude and trend; use the waterfall when you explain a gap between two numbers.
The wrong choice confuses the reader. A waterfall with six regions looks like noise, and a combo trying to explain a single bridge buries the story. Match the chart to the question before you touch the ribbon, and your slide will need far less解释.
Build a combo chart (bars plus a line)
Use a small table with Month, Revenue, and Profit columns. Put Revenue and Profit as numbers, not text. Excel needs real values to plot, so type 12000 under Revenue for Jan rather than '12k', or the chart will not scale.
Select the Month and Revenue columns, open Insert, and choose Clustered Column. You now have bars for Revenue. Keep this selected; the next step adds the second series as a line on top of the same plot.
Right-click the chart, choose Select Data, then Add. Name the series Profit and point Series values at your Profit column. Press OK. You now have two column series overlapping on the same canvas.
Click the Profit bars, open the Chart Design tab, and choose Change Chart Type. Pick Line for Profit while Revenue stays Column. This is the combo. I recommend a solid line with markers so it reads clearly on a projector.
If Profit is tiny next to Revenue, right-click the line, open Format, and tick Secondary Axis. The right side gets its own scale. A common mistake is leaving both on one axis, which flattens the line into the floor where no one sees it.
I recommend labeling the line's end point with a data label showing the final Profit value. Right-click the line, add Data Labels, and set them to show Value. It saves readers from squinting at the right-hand axis during a meeting.
Build a waterfall chart
Excel 2016 and later ship a Waterfall chart type. It reads a base value, then rises and falls with each step. For a bridge from Revenue to Profit, your steps are Costs and Taxes. The first and last bars are totals; the middle bars float to show the change.
List rows as Revenue, Costs, Taxes, Profit. Enter 120000 for Revenue, -45000 for Costs, -12000 for Taxes, and the final Profit as a totals row. Negative steps fall; the total is the landing bar that closes the bridge.
Select the table, open Insert, expand the Waterfall icon under Stock charts, and click Waterfall. Excel colors increases green and decreases red automatically. This will break if a step value is text instead of a number, so check your cells first.
Right-click the Revenue bar, choose Set as Total. Do the same for Profit. Totals bars span full height; step bars float. In my experience forgetting this leaves Revenue as a floating bar that looks like a change rather than a starting point.
Open Format and set Increase to a dark green and Decrease to a red that survives grayscale. A common mistake is a light red that vanishes when printed in black and white. Test a print preview before you share the file with the team.
Avoid more than six steps in one waterfall. Past that, readers lose the thread. Group tiny items like 'Bank fees' into a single 'Other' bar so the story stays clear: Revenue down to Costs down to Taxes equals Profit.
Profit and loss bridge with real numbers
Take a Q1 view: Revenue $120,000, Costs $45,000, Taxes $12,000, leaving Profit $63,000. The waterfall walks from 120000 down by 45000 to 75000, then down by 12000 to 63000, which is the number your manager actually cares about.
Enter those four values and insert the Waterfall. The first bar shows 120000, the Costs bar drops to 75000, the Taxes bar drops to 63000, and Profit lands as a total. Each drop is labeled with its dollar amount automatically.
If you compare to a $70,000 target, add a combo line of the target across the bridge. Select the chart, add Target as a line series on the secondary axis. This shows the $7,000 gap visually without building a second slide.
Click the Costs bar and add a text box reading '45% of revenue'. Because Costs are $45,000 of $120,000, that percentage anchors the story. Use real ratios like this instead of vague 'high costs' wording that means nothing to a reader.
Common chart mistakes
Most bad charts come from scale or count errors, not from ugly colors. Fix the data structure first and the chart almost builds itself. Below are the three issues I see most in shared workbooks from new analysts.
Putting Revenue in dollars and Region count on one combo without a secondary axis misleads. A common mistake is a line that looks flat because its scale is hidden. Always show both axes or split the charts into two panels.
A combo with five series becomes noise. Keep to two or three. If you need more, build a small multiples grid instead. This will break comprehension once legends overlap and the reader cannot tell which line is which.
Do not use a waterfall to compare regions; use a clustered column. The waterfall explains a single bridge, not a category comparison. Match the chart to the question or the reader guesses and loses trust in the numbers.
Feed charts from Tables for live updates
If your source is an Excel Table named Sales, the chart grows when you add rows. See our chart selection guide for when a line beats a bar. A Table-backed chart means January's new data appears without you re-selecting ranges by hand.
Press Ctrl+T on your Month, Revenue, Profit range and name it Sales. The chart's Select Data now points at Sales[Revenue] style ranges. Add February and the combo updates on open with no extra clicks from you.
Tables update automatically, but if you pasted values, press Ctrl+Alt+F5 to refresh all. A common mistake is editing the table yet seeing a stale chart because the link was a fixed range like B2:B13.
Next steps
Build one combo and one waterfall on your own data this week. Start from a Sales table so the charts stay alive when rows arrive. Then read our dashboard guide to place these charts on one screen for your manager instead of three separate tabs.
I recommend saving a finished combo as a chart template. Right-click the chart, choose Save as Template, and reuse it across reports so colors and axes stay consistent without you rebuilding the same layout every month.
I recommend giving the combo secondary axis the same maximum as the waterfall total, so a $120,000 Revenue bar and the bridge start sit at the same height. A common mistake is letting each chart autoscale, which makes the same number look different across the two panels and undermines the comparison. I set both axes to a fixed 120000 and label the Profit line with its final value, so a reader sees the $63,000 landing without squinting at the right-hand scale during the meeting.
Putting combo and waterfall on one dashboard
A manager rarely wants one chart alone. Place the combo of Revenue bars with a Profit line above the waterfall bridge so the trend and the gap sit on one screen. Link both to the same Sales Table and they refresh together when March closes.
I keep the combo on the left and the waterfall on the right, with the variance line carrying the same $7,000 gap color in both. When the numbers match across the two charts, the story reads in five seconds instead of two slides. This is the layout I send before a monthly review.
Give the combo's secondary axis the same max as the waterfall's total so the $120,000 Revenue reads at the same height as the bridge start. A common mistake is letting each chart autoscale, which makes the same number look different and undermines the comparison.
Export the paired view as a single image only when the reader is static; for a live deck keep the native charts so they update. A linked Table means the next month's numbers flow in without redrawing anything, which is the whole point of building them this way.
