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.
Column + Line Charts can be used for a wide variety of cases. Here are some frequent ones we see.
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. Go ahead and select Column + Line Chart.
Next, you’ll need to select your data series. Note that the first data series you select will be the column, and any subsequent data series you select will be a line.
Once you’ve selected your data series, you can format each series. (Check out the second section of the article to learn how to do formatting.)
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 that these two series, we suggest using the Stacked Column + Line Chart.
Questions about Column + Line Charts? Chat in on the site and we’ll be happy to help.