11/26/2023 0 Comments Waterfall chart![]() ![]() Now you’ve got a pretty waterfall chart that should look something like this. Change the “Series Overlap” to 100% and the “Gap Width” to 15%.Double click on a column, select “Format Data Series,” and click on “Options” in the left menu.This will make the chart “pop” a little more. You can also get rid of that extra white space between your columns. Here’s how your waterfall chart should look now. Pick a separate color to make them stand out. Make sure to individually color code your start and end columns.Repeat the process with your Up column.Do the same with the Line option in the left menu.We went with blue to make it stand out more. Select Fill, then pick the color you want. ![]() Select the Down series, right click, then select “Format Data Series.”.In our example above, we want to differentiate between our Up and Down columns. Maybe add some color, a few more details for context, and give it a title. Your Excel waterfall chart’s a little drab, and you want to spice it up a bit. ![]() We’ll talk about how to make your chart pretty. But if you’re like us, you don’t go for basic. You’ve now created a basic waterfall chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |