请教EXCEL 达人如何做waterfall chart

2025-03-11 05:25:23

推荐回答（1个）

回答1：

本教程介绍如何制作瀑布图。我将使用一个表的一列显示的想法，但它不是太难的两个或两个以上变量做。在页面的底部，你可以找到两个样本的Excel表。瀑布1步。在我的瀑布图，我想总的，但它是直接通过删除电子表格中的总计行删除它，或通过图表源编辑。这是一个模板，如果你赶时间excel-logo.png瀑布图2步骤。小心你进入第二列的公式。我可以用“=总和（C7：C11）”这一公式的运用细胞下面没有什么不同，但如果你决定让更多的数字仅低于第一列，那么你就麻烦了…移动…瀑布图3步骤3。如果你点击“预览”按钮，你会发现它看起来不好，不过别担心，我们会到达那里…瀑布图4步骤4。是的，现在我们有了骨架。瀑布图5步骤5。在这一步，我想尝试去酒吧我会看不见。这将把我从右键单击选择“数据系列格式”。小提示：小心挑杆组，不只是一个酒吧，或整个图瀑布图6步骤6。我希望“打印屏幕显示鼠标指针的时候，但你的想法…瀑布图7步骤7。有些人不喜欢瀑布图下的网格线，如果你是其中之一，选择白色的边框和填充颜色，而不是挑选“无”（抱歉显而易见：P）瀑布图8步骤8。只是一个修饰，我喜欢，你不需要…事实上，如果你有一个以上的变量，你可能想玩的重叠和间隙宽度一点点瀑布图样品OK，在这里..希望这有助于。随意使用这个Excel表作为指南。　　This tutorial shows how to make a waterfall chart. I will use a table with one column to show the idea, but it's not too hard to do it for two or more variables. At the bottom of the page you can find two sample excel sheets.

　　waterfall 1
　　step1. in my waterfall chart, i wanted to have the total, but it's straightforward to remove it by either deleting the total row in the spreadsheet, or by editing the chart source.

　　here's a template if you're in a hurry excel-logo.png
　　waterfall chart 2
　　step2. be careful with the formula you enter for the second column. i could have instead used "=sum(C7:C11)" applying this formula to cells below would make no difference, except if you decide to put more numbers just below the first column, then you'd be in trouble...
　　moving on...
　　waterfall chart 3
　　step 3. if you click on the preview button, you'll see that it doesn't look that good, but don't worry, we'll get there...
　　waterfall chart 4
　　step 4. yes, now we have the skeleton.

　　waterfall chart 5
　　step 5. in this step, i think ahead and try to pick the bars i'll make invisible. this will save me from right-clicking and choosing "format data series" again.

　　small note: be careful to pick the group of bars, not just one bar, or the whole chart

　　waterfall chart 6
　　step 6. i wish 'print screen' showed the mouse pointer sometimes, but you get the idea...

　　waterfall chart 7
　　step 7. some people don't like gridlines under the waterfall chart, if you're one of them, pick white for the border and fill colors instead of picking "none" (and i'm sorry for stating the obvious :P)

　　waterfall chart 8
　　step 8. just another modification i like, you don't have to... in fact, if you're dealing with more than one variable, you might want to play around with the overlap and gap width a little bit

　　waterfall chart sample
　　ok, here it is.. hope this helps. feel free to use this excel sheet as a guide.

最新问答

象棋中，一上来就卖炮换了你的马，这种开局有专业术语吗？叫什么？

办公室里都是用局域网连服务器,怎么又一台有外网了呢,用的是同一台交换机。怎切换回来内网

陈林?求加一个字适合男孩名字的

算命的说我三年之内要出车祸死是真的吗请问一下，在算命的还是信还是不信？

十大最适合创业的点子

去上海走京沪高速能不能路过润阳大桥