Column + Line Charts are extremely versatile. Here we’ll show you some tips and tricks for using this kind of chart and how to build it.
Trends over time. If you have any kinds of sums and want to see the percentage relative to a whole, this chart type is very useful to track that. You can add columns for a certain time period and a line for the percentage comparison.
Comparing Time Periods. One easy way to visualize how your company performed this quarter (or month, or 90 days, etc.) compared to last quarter (or relevant time frame) is by using a Column + Line Chart. Set the column data series to your current period’s data, then use the line data series to the same time frame just prior to the current one.
Total Sales Revenue Amount & Total Sales Counts. This sales metric lets you see your total revenue amount compared to the number of sales. This can give you an idea of how large of sales you are selling.
Building a Column Chart
To build a column + line chart, first log in to your Grow account and click Add Metric. Choose your data source, and connect your data.
In Edit Metric, click on Column to reveal the chart type menu. Select 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.
Check out this article to learn about the other standard formatting options.
Tip: Using 2-Value Axes
Note: Given that this chart type is often used for comparisons, one formatting option that may help your chart is to use 2-value axes.
2-value axes are useful when each data series may be on a different scale. For example, if my sales revenue is in the thousands, but my actual count of sales is in the hundreds, 2-value axes would allow you to see both without unnecessarily squishing one data series or the other because of its relative size.
To enable 2-value axes, click the CHART tab, then select Display and check the box labeled Enable 2 Value Axis Chart.
Please note that when you enable 2-value axes, your metric will only be able to support one column and one line data series. Any additional series you have selected will not be displayed.
If you need to display more than these two series, we suggest using the Stacked Column + Line Chart.