How to create a waterfall chart
The waterfall chart allows you to plot values as bars, however, depending on whether they are negative or positive numbers the total is added or subtracted. The columns have different colors based on if the value is less than 0 (zero) or larger than 0 (zero) and they are connected with lines to make it easier for the reader to follow.
The waterfall chart is great for displaying financial information like income statements. It shows the cumulative effect for each activity and the outcome.
How to build
- Select data.
- Go to tab "Insert" on the ribbon.
- Press with left mouse button on "Insert Waterfall, Funnel, Stock, Surface or Radar chart" button
- Press with left mouse button on "Waterfall chart" button.
- The chart now looks like this.
- Double press with left mouse button on on chart column "Costs of goods sold" to open the task pane.
- Press with mouse on chart column "Costs of goods sold" until only the column is selected The other columns are faded out if only one column is selected.
- Press with left mouse button on checkbox "Set as total".
- Repeat step 7 - 8 with remaining columns containing positive values.
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.