To explain how to create a bridge chart we are going to use dummy data. The waterfall chart will show the individual components of the profit and loss. Follow the steps below to create a bridge chart:
Enter dummy data like shown below.
Now you have to create a stack flow chart. To do this click on the "INSERT" tab then click on "Insert column chart" under the Charts group. Select Stack Column.
A chart has been created but it doesn’t look like a bridge chart, to change this right click on any one of the blue column (Excel will select all of the blue ones) and select "Format Data Series". A dialog box appears, where select "No fill".
To look like a waterfall chart on the same dialog box in the "Series Options" tick "Gap Width" 0% ("No Gap").
For even more attractive graph format the column revenue and profits by setting fill in blue.
That’s it! Your bridge chart is now ready.