This article will show you how to build and use a stacked column + line chart in Grow.
The following are some use cases we’ve seen or done with stacked column + line charts. See how you could modify some of our examples to fit your company’s specific metric needs.
Trial Fallout Rate. If your company offers any kind of a trial, this one could be useful. For the stacked column, measure the number of deals closed and the number of trial fallouts (stacked column), then compare it with the net deals closed from that group (line). You could also change the line series to be a percentage of the trials that closed or the percent churned over a specific time period. Another modification could be to measure cohort retention at the renewal date.
Opportunities by Source. A stacked column + line chart could break down the opportunity or lead types that are coming in by different sources (stacked column) and the number of closed deals from those by day.
Do you have more examples? Let us know!
How to build a stacked column + line chart
To build a stacked column + line chart, first log in to your Grow account and click Add Metric. Choose your data source, connect your data, and press continue.
In Edit Metric, click on the chart type menu to view the list of charts. Go ahead and select Stacked Column + Line Chart.
Next, you’ll need to select your data series. Note that the first data series you select will be the line, and any subsequent data series you select will form a stacked column.
Please note, however, that unlike the column + line chart, 2-value axis formatting is not available with the stacked column + line chart.
Once you’ve selected your data series, you can format each series. (Check out this article to learn how to do formatting.)
Questions about Stacked Column + Line Charts? Chat in on the site and we’ll be happy to help.