[Excel] How to make a bowtie plot

A bow tie chart is a fun chart to display the proportion of a category on both sides of a budget, like capital revenue vs. capital expenditure.

Excel bowtie chart.

Design notes

• This chart was designed to display the proportions of a pair of variables in some type of input - output table, like revenue - expenses.
• Use a stacked area chart with a hidden series and a hidden row in the middle.

Video

Notes