12/23/2023 0 Comments Waterfall bar tableThe values in each brick represent the monthly sales, and the brick’s position with respective values on the left axis represents the accumulated sales. If you observe, we can see both monthly sales and accumulated sales in the singles chart. Then you will get the values on the bricks for better visibility, change the brick color to light blue.ĭouble click the “chart title” and change to the waterfall chart. Select the blue bricks and right-click and select the option” Add Data Labels”. If you want to see each month’s sales in the chart, you can add the values to the bricks. If you observe the chart, it looks like water falling from up to down or “flying bricks,” which is why it is called a waterfall or flying bricks chart. Select the total bar alone and fill in some colors as your wish, then it looks like below. Now the chart will look like the below picture. So that orange bars will change to white color (colorless). Now select the orange bars and do a right-click click on the “fill” option available, select “No fill”. The blue color appears on the up, and orange appears at the bottom. Click on “Accumulation” and then click on “up arrow” as marked with red color. When you click the “Select Data”, one menu will pop up as below. Select the chart or bars and right-click you will get the pop-up menu from that menu, select the “Select data” option. Now we need to convert this stack chart to a waterfall chart with the below steps. Now select the entire data range and go to insert >charts >column >under column chart > select Stacked column as shown in the below screenshot. Now copy the formula to all other months as shown in the below screenshot so that we will get the accumulated sales of each month. Later insert the formula for adding January sales to February sales in the accumulation row under the February column, as shown in the screenshot below. First, copy the Jan sales in the first cell of accumulation as shown below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |