什么是瀑布图
Last month your revenue was $40,000 and this month it's only $30,000? What happened? In Excel, you could print a nice report that shows each revenue stream for last month and this month, so you can compare the amounts.
上个月您的收入是$ 40,000,而本月只有$ 30,000? 发生了什么? 在Excel中,您可以打印一个不错的报告,显示上个月和本月的每个收入流,以便您可以比较金额。
You could even create a bar chart to compare the different revenue streams.
您甚至可以创建一个条形图来比较不同的收入来源。
The bar chart lets you see the differences for each stream, but maybe you'd like to see how each revenue stream contributed to the overall change in revenue.
条形图使您可以看到每个流的差异,但是也许您想查看每个收入流如何对收入的总体变化做出贡献。
A waterfall chart will let you see the changes that occur between a starting point and an ending point. In Excel, you can create a waterfall chart by building a column chart, and making some changes to it.
瀑布图将使您看到在起点和终点之间发生的变化。 在Excel中,可以通过构建柱状图并对其进行一些更改来创建瀑布图。
创建一个新表 (Create a New Table)
The first step in building a waterfall chart is to create a table that calculates the individual changes, and a running total. In the example below:
制作瀑布图的第一步是创建一个表,该表计算各个变化和运行总计。 在下面的示例中:
- June and July revenues are at the far right. 6月和7月的收入在最右边。
- F3 is the total for June. F3