This method may seem a little complicated. But there is a way around doing that using the Stacked Column Chart. Unfortunately, there is no direct way to create a Waterfall Chart in Excel 2013 and earlier versions. Create a Cash Flow Waterfall Chart in Excel 2013 and Earlier Versions Read More: Create Cash Flow Statement Format with Indirect Method in ExcelĢ. So don’t get frustrated if you can’t format this chart like other chart types. Note: The Waterfall Chart type has limited formatting options. You can do the same to the Start column also as it is merely the total balance at the start. Finally, the Total column will look as follows.Now right-click on that column and select Set as Total as follows.This will select that column and all other columns will become blurred out. So, triple-click on that column or click twice (not double-click) to select it.
In this case, the End column contains the total cash flow of the year.
CASH FLOW STATEMENT GRAPH SERIES
Right-click on any column and select Format Data Series to do that. Another way to make the labels fit properly is by making the columns wider.Now, you can set the decimal places to 0 and remove the $ symbol if you want to make the labels shorter.So, right-click on any data label and select Format Data Labels. Now, notice that the Data Labels are not properly visible.You need to select the chart to access those options. Alternatively, you can use the Chart Design and the Format tabs to do that.
Then enable Axis Title using the Chart Element menu at the top-right corner of the chart and rename them. For example, click on the Chart Title and rename it as desired.
0 kommentar(er)
