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.
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 by default the first data series you select will be the column, and any subsequent data series you select will be a line. You can change the format (column or line) of each in the "Data Series Type" dropdown of the data series settings (under the color picker). When displaying a line, you can also change the line thickness and style, and choose to display round bullets for each data point on the line.
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.)