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
Other People Are Reading
Click the “Chandoo.org” 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 Chandoo.org’s Sky Drive page appears, the blue rectangle relating to your chosen “excel-waterfall-chart-template” file will be highlighted.
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.
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.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for