![]() Right-click on “Base” in the legend, then select “Delete” from the dropdown.With the base section now excommunicated from our Excel waterfall chart, we can take it out of the legend. Do the same thing with the “Line” section.Click on Fill in the left menu, then “No Fill” in the color dropdown box.Click on the Base series, then right click and select “Format Data Series” from the dropdown.We’re ready to grow our stacked chart into a wonderful, well-respected waterfall chart. Let’s make that happen, shall we? Step 4: Turn Your Stacked Chart Into a Waterfall ChartĮveryone has a little room for growth, including our dear stacked chart. Look at that! It’s got your numbers and everything. Click “chart” then select “stacked chart” from the list.Be sure to include your headers and leave out the Income Flow column. Highlight all the data you want to include in your chart.Moving on… Step 3: Make Your Data Table a Column Chart And (boom!) your waterfall chart should now look like this. Use the fill tool to drag the formula down to the bottom of the column again. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |