I. Tools: excel20 10
Second, the operation steps:
1. Enter excel20 10, select the cell area where you want to make a waterfall diagram, click Insert, and then select a two-dimensional accumulation diagram, as shown in the following figure:
2. At this point, a chart with two columns of data will be automatically generated. Select the following column of data to display the chart, click the right mouse button and select Format Data Series, as shown in the following figure:
3. Select "Fill" in the series options, then set it to not fill, and press the "Close" button, as shown in the figure:
4. Then right-click the chart column chart and select Add Data Label, as shown:
5. This beautiful waterfall map is completed, as shown in the following figure:
How to make a waterfall map with advanced feeling in Excel Excel? Excel waterfall chart looks like a waterfall, with a smooth effect from top to bottom.
Excel waterfall chart is widely used in business analysis and financial analysis of enterprises to show the composition and changes of enterprise costs.
By constructing a placeholder auxiliary column, a waterfall chart is generated by using the stacked histogram, and then the chart format is optimized.
1. Prepare placeholder data.
To the left of the Cost column, insert a column of numbers.
"Total Cost" corresponds to "Number of Positions" of 0.
Size of the nth placeholder data = (total cost-(cost 1+ cost 2+ cost 3+ cost n))
For example, insert the formula =$C$2-SUM($C$3:C3) in the "B3" cell.
According to the above formula, we can get the corresponding share of each cost.
2. Insert "stacked column chart"
Select the data in the table, and on the Insert tab, click Chart Column, and then click Stacked Column.
The effect after inserting the stacked column chart is shown in the figure.
3. Set the color of the chart column corresponding to the occupation number as transparent.
Select any column where the Occupation Number is located. Click the right mouse button, and in the color "Fill" option, set "No Fill Color".
This hides the placeholder data columns.
Step 4 beautify the chart
Optimize the chart style according to the needs of personal projects.
1) Modify the chart title.
2) Delete the legend and grid lines.
3) Hide labels and tick marks on the ordinate.
4) Use the mouse to select any column in the remaining expenses, right-click and select "Add Data Label".
Excel waterfall map completed! ! !
Excel waterfall chart is widely used in business analysis and financial analysis of enterprises, and is often used to represent the composition and changes of enterprise costs.
Excel makes waterfall chart, which is to generate waterfall-style chart by constructing occupation auxiliary column and superimposing histogram.
If you need to use the case data in the article, you can reply to the waterfall map in the comment area.
Ask EXCEL experts how to make waterfallchart? This tutorial introduces how to make a waterfall map. I will use a column of a table to illustrate this idea, but it is not too difficult for two or more variables. At the bottom of the page, you can find two sample Excel tables. Waterfall 1 step. In my waterfall diagram, I want to summarize, but I can delete it directly in the spreadsheet by deleting the summary line, or edit it through the chart source. This is a template, if you are in a hurry, waterfall figure 2 steps. Notice that you enter the formula in the second column. I can use the formula "= sum (C7:C 1 1)". There is no difference under the cell, but if you decide to make more numbers lower than the first column, you will have trouble moving the waterfall. Figure 3, step 3. If you click the "preview" button, you will find it looks terrible, but don't worry, we will get there. Yes, now we have a skeleton. Waterfall Figure 5 Step 5. At this point, I want to try going to a bar. I won't watch it. This will take me right-click and select Data Series Format. Tip: be careful of the pole group, not just one pole, or the whole waterfall, Figure 6, Step 6. I want to print the screen when the mouse pointer is displayed, but your idea falls in step 7 of Figure 7. Some people don't like the grid lines under the waterfall map. If you are one of them, choose white border and fill color instead of "none" (sorry, obviously: P). Step 8 of waterfall figure 8. It's just a decoration. I like it. You don't need it. In fact, if you have more than one variable, you may want to use the waterfall diagram example to deal with a little overlap and gap width. Here ... I hope this helps. Please feel free to use this Excel table as a guide. thistutorialshowshowtomakeawaterfallchart。 I use onecolumntoshowtheidea, but not nottoohardtoitdoworwoolvaryables. attthebottomofthepageyoucanfind two sampleexcelsheets.
Waterfall 1
Step1.inmaywaterfallchart, iwantedtohavethetotal, but its traightforwardmoveitbyeitherdeletinghettototorowinthespreadsheet, or byeditingthechartsource.
If you are hungry, here is the template.
Waterfall Figure 2
Step 2: use formulayouenterfor the second column. icouldhaveinstead "= sum (C7: c11). "You are in trouble when you apply this formula to the Applyingthisforformatlocellslowwouldmakenodifference, exceptionYouDecidePutmoreNumbersjustbelowtheFirst column. ...
Keep moving ...
Waterfall Figure 3
Step 3: If you click the "Review" button, you will see that it doesn't look good, but don't worry, we will get there. ...
Waterfall Figure 4
Yes, now we have a skeleton.
Waterfall Figure 5
Step 5. In this step, IthinkaheadandTrytopickthebarsi' will be made invisible. This will save me from right-clicking and selecting Format Data Series again.
Note: Becareful topic is grouped of bars, not just a bar chart or the whole chart.
Waterfall Figure 6
Step 6: I hope "printscreen" sometimes shows the mouse pointer, but you don't. ...
Waterfall Figure 7
Step 7: Some people don't like the grid lines under the waterfall map. If you are a new member of them, choose white as the border and choose the fill color.
Waterfall Figure 8
Step 8: Just another modification, for example, you can't veto ... In fact, if you are using more than one variable, you may want to use overlapandagpwidthlittlebit.
Waterfall diagram example
Ok, this is ... hopeishelps. feel free tous thisexelshetasguide.