If a number changes or the zoom is changed, those lines will need to be repositioned manually.Īlso missing from Figure 1 are numeric labels. The horizontal bars between columns are static lines drawn in by hand. In the final chart, both of these series are colored aqua to make it look like a single series. In order to make that appear as a single column, you need one series to represent the $0 to $20,000 portion of the column and another series to represent the $0 to -$30,000 portion of the column. All of this trickery is required to make the April column appear as if it starts at $20,000 and dives down $50,000 to end up at -$30,000. The larger chart in Figure 1 shows the results after two series are set to have no fill and the five other series are set to have three colors. Figure 2 shows the data for seven series. The inset identifies the seven different series needed to create the chart: (1) opening and closing values, (2) increases above the 0-axis, (3) decreases above the 0-axis, (4) invisible (no fill) positive, (5) increases below the 0-axis, (6) decreases below the 0-axis, and (7) invisible (no fill) negative. Figure 1 shows a waterfall chart created in an earlier version of Excel.
0 Comments
Leave a Reply. |