How to create a flying brick chart in Excel

Written by frank luger Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to create a flying brick chart in Excel
Waterfall charts replicate the visual appearance of a waterfall, to some extent. (Jupiterimages/ Images)

A flying brick chart is also known as a waterfall chart, according to the owner of an online video training company, Ben Fhala. As of March 2013, you cannot do a waterfall chart in Excel using the standard chart types. Although there is a complex workaround to this, you still have to be happy with several compromises, like having to make manual readjustments to the connector lines, for example. The easiest way, therefore, is to use a template.

Skill level:
Moderately Easy


  1. 1

    Click the “” link under Resources. Scroll down the page to “Download the Waterfall Chart Template:” and click “here” for the unzipped version or “[.zip version here]” for the zipped version. When’s Sky Drive page appears, the blue rectangle relating to your chosen “excel-waterfall-chart-template” file will be highlighted.

  2. 2

    Right-click the blue rectangle and click “Open in Excel.” The file will open with dummy data which has been charted in waterfall chart, or brick chart style. Take a moment or two to get up to speed with what is being displayed here.

  3. 3

    Edit the file to make it fit your chosen subject and data. Enter your axis labels, which are, essentially, column headings. Enter your element values which are the values relating to the axis labels.

  4. 4

    Change the label spaces if you wish to have the label above each column sit at a higher or lower level. The connector values will automatically update via the SUM function in accordance with your base values and element values.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.