An introduction to how to create a waterfall chart in Excel

php editor Yuzi introduces you to a method of making Excel publishing charts. Excel is a powerful spreadsheet software that can be used for data analysis, statistics, reports and other purposes. Making Excel publication charts can display information more intuitively and improve the effect of data communication. This article will introduce in detail how to use the functions of Excel to create beautiful and clear release diagrams, and give practical cases to explain. No programming knowledge is required, just simple operations and it can be easily implemented. Follow the editor's steps immediately and start making your own Excel publishing chart!

1. Column A is an entry.

Column B is a numerical value. Increasing bits are positive values ​​and decreasing bits are negative values.

2. The cumulative item uses the summation formula to return the cumulative value

B2=SUM(B2:B8).

1. 1. Select the data area

2. Insert

3. Insert the waterfall chart

4. The result is displayed.

Set the cumulative as a summary item

1. Click the waterfall chart

2. Double-click the cumulative histogram to pop up dialog box.

3. Check the box and set it to summary

The above is the detailed content of An introduction to how to create a waterfall chart in Excel. For more information, please follow other related articles on the PHP Chinese website!