[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 chart displaying data as a bowtie
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.