Last November, my husband and I were on our honeymoon in Maui. One of the main activities we wanted to do was a hiking tour near the waterfalls. We dreamt of swimming in the cascading water at sunrise.<\/p>\n\n
When you hear the word \u201cwaterfall,\u201d that\u2019s typically what you imagine. However, today, we’re going to talk about a different kind of waterfall \u2014 the waterfall chart.<\/p>\n
<\/a><\/p>\n Waterfall charts are a data visualization resource that can help you gather and track important data such as traffic goals and lead generation. Below, let’s review what a waterfall chart is, how to read one, and how to create one.<\/p>\n\n In marketing, a waterfall chart could display the number of leads, traffic sources, or blog views over a period of time. More specifically, you could use a waterfall chart to showcase how your blog traffic has increased or decreased in the last year, giving values month over month.<\/p>\n You could potentially use line charts, bar charts, and even bullet graphs to show this type of data. But waterfall charts have the advantage of showing your gains as they\u2019re impacted by losses over time.<\/p>\n You should use a waterfall chart instead of other types of charts when trying to visualize data that experiences both gains and losses. It\u2019s especially useful if you want to see how a loss affects a subsequent value.<\/p>\n Image Source<\/a><\/p>\n One of the reasons that waterfall charts are effective in marketing is because they give context to the data it’s reporting. Most data visualizations<\/a> suffer from ignoring circumstances that result in a fall or rise in numbers, such as seasonality.<\/p>\n For instance, let\u2019s say you create a waterfall chart of your Twitter followers over time. Rather than using a line graph that shows your total number of users over time, a waterfall chart shows how many you lost \u2014 and how that impacts subsequent figures.<\/p>\n At first glance, these charts can be difficult to read. Below, let’s review how to read a waterfall chart.<\/p>\n Reading a waterfall chart will seem foreign at first if you’ve never done it.<\/p>\n However, it’s important to remember that you’re reading it sequentially, from left to right.<\/p>\n For instance, let’s say you’re tracking blog traffic from month to month. On the far left, you’ll have the total traffic from the previous year. Then, you’ll include the gains and losses month over month for the entire year. At the end of the chart, you’ll see the total traffic for the year.<\/p>\n Here’s what that looks like:<\/p>\n\n Notice how each value ends either where the previous value ended or began. In January, there was a gain of 5,000 visitors, but in February and March, there was a loss of 2,000. April\u2019s traffic value takes that into account by starting from the -2,000 figure and going up from there.<\/p>\n Essentially, a waterfall chart is supposed to show you where you started and where you ended up, with details of how you got there. In this example, you can see which months gained the most traffic compared to the months that lost traffic. This could help you see seasonal adjustments, while also keeping the big picture in mind.<\/p>\n Now, you might be wondering, “That chart looks difficult to make. How can I make my own in Excel?” Below, we’ll review the simple process of creating your own waterfall chart.<\/p>\n\n Not sure how to actually get it done? Below, we include a template and further instructions.<\/p>\n Bonus: You\u2019ll also find instructions for creating waterfall charts in Google Sheets, in case that\u2019s your preferred spreadsheet software.<\/p>\n Before creating your chart, you\u2019ll need to compile the data you\u2019d like to use.<\/p>\n For example, are you tracking blog traffic numbers? Or perhaps you’re looking at leads generated from a certain marketing campaign? Either way, before you can create a waterfall chart, you’ll need to gather your data.<\/p>\n For this template, we\u2019ll track blog traffic. Create a table with four columns. The first two columns will have no headings. In cells A2 to A15, write START, then all 12 months, then END.<\/p>\n\n Open Excel or Google Sheets, and begin manually entering your data. When you enter your data, make sure you denote the difference between positive and negative values. To denote a negative value, just add a minus sign in front of the number.<\/p>\n Note: all numbers in this example are arbitrary and not reflective of traffic to any blog.<\/em><\/p>\n <\/em><\/p>\n In cell C1, write \u201cGAIN,\u201d and in cell D1, write \u201cLOSS.\u201d<\/p>\n From there, place your traffic numbers. How much traffic are you starting with? Write that in cell B2, next to START. Then, for each month, write how much you gained or lost.<\/p>\n Add everything together, including negative values, and place them in cell B15, next to END.<\/p>\n Now that you have your values, highlight the table you just created.<\/p>\n If using Google Sheets<\/strong>, go to Insert \u2192 Chart \u2192 Waterfall chart.<\/p>\n This will create a waterfall chart and the Chart Editor will show up on the right-hand side. When the Chart Editor comes up, make sure that \u201cWaterfall Chart\u201d is selected under Chart Type.<\/p>\n\n If using Excel<\/strong>, go to Insert \u2192 [Waterfall chart symbol] \u2192 Waterfall.<\/p>\n\n Your chart will automatically be created based on the values in our template.<\/p>\n At this point, all the hard work is done. All you have to do is format your chart and make sure it looks how you want.<\/p>\n In Google Sheets<\/strong>, click on the three dots in the upper right-hand corner of the chart and hit Edit Chart. You’ll get to the Chart Editor. Here, you can choose the colors of your bars, adjust your legend, or add gridlines. Most likely, the main thing you’ll want to do here is to adjust your legend.<\/p>\n In Excel<\/strong>, you\u2019ll click on the chart, then choose \u201cChart Design\u201d and \u201cFormat\u201d on the top ribbon to make the chart look the way you want it to.<\/p>\n\n The process of creating a waterfall chart manually can be a hassle. Luckily, you can also create a waterfall chart using a dedicated dashboard tool. For example, HubSpot offers marketing dashboard and reporting software<\/a> that you can use to create charts<\/a>. Here’s how.<\/p>\n Once you log in to your portal, hover over the Reports tab and click into the Analytics Tools.<\/p>\n\n Next, you’ll choose what you want to track. Perhaps you want to analyze blog traffic like we did in the example above. Or maybe you want to review analytics for a certain campaign.<\/p>\n Either way, you can choose what you want to track in the Analytics Tools.<\/p>\n\n Lastly, all you have to do is choose the style chart you want. Right now, you can choose between an Area chart, Column chart, Line chart, or Combination chart. You\u2019ll want to choose \u201cColumn,\u201d which is closest to the waterfall chart format.<\/p>\n\n To recap, here\u2019s how to understand your waterfall chart:<\/p>\n A waterfall chart shows a series of negative and positive values. Each value impacts the value after it.<\/p>\n Example:<\/strong><\/p>\n If one week you lose 3 leads, the next value will take that into account. If you gain 5 leads, the waterfall chart will use -3 value as a starting point, so that your ending point is a gain of 2 leads.<\/p>\n Each column is color-coded to distinguish positive from negative values.<\/p>\n Now that we have refreshed how to read and understand a waterfall chart, let\u2019s dig into how to analyze it.<\/p>\n Which months or weeks did you see the greatest losses? It\u2019s important to see and understand these figures to get the most out of your chart. From there, you can troubleshoot or come up with a new strategy for those months.<\/p>\n Conversely, look at the time ranges that saw the greatest gains. You\u2019ll want to emulate what you did during those months \u2014 or research trends that gave you a boost during those times.<\/p>\n From start to end, how big of a difference did you see? Was it a positive or negative difference? Could your business have seen better results?<\/p>\n After creating a new strategy, it\u2019ll be helpful to use a waterfall chart to see how it impacts you from week to week \u2014 whether you\u2019re seeing more positive or negative results.<\/p>\n To ensure you’re examining the full scope of your analytics, we recommend creating a waterfall chart. It’s a worthwhile data visualization tool that can help you understand your analytics sequentially. No longer do you have to rely on typical line graphs \u2014 with a waterfall chart, you\u2019ll understand your gains and losses over time at a much more granular level.<\/p>\nWhy use a waterfall chart?<\/h3>\n
How to Read a Waterfall Chart<\/h2>\n
Waterfall Excel Template<\/h2>\n
1. Gather your data.<\/h3>\n
2. Create a table with four columns.<\/h3>\n
3. Enter your data in Sheets or Excel.<\/h3>\n
4. Add up your values.<\/h3>\n
5. Highlight all of your data.<\/h3>\n
6. Insert your waterfall chart.<\/h3>\n
7. Format your waterfall chart.<\/h3>\n
How to Create a Chart in HubSpot<\/h2>\n
1. Go to Analytics Tools.<\/h3>\n
2. Choose what you want to track.<\/h3>\n
3. Choose the chart type.<\/h3>\n
Waterfall Analysis<\/h2>\n
1. Examine the time ranges with the greatest losses.<\/h3>\n
2. Examine the time ranges with the greatest gains.<\/h3>\n
3. Examine the net change over the entire time range.<\/h3>\n
4. Look at week-to-week gains and losses after implementing a new strategy.<\/h3>\n
Use a waterfall chart to better analyze your performance.<\/h2>\n