Trying to use a line-bar combination chart but can’t quite figure it out? Use these charts in one of two ways:
First, you can easily overlay two metrics to get a sense for the trend across both metrics, rather than just analyzing one metric at a time, which is the standard for most other charts. Line-bar combination charts let you have two y-axes, instead of just one.
The second way this chart can be used is to show an actual versus goal, with the actual in the bar, and the goal in the line. In this use though, we recommend that you get a bit creative with the line, and use the Format Chart Data option to add a colored symbol to the line (such as a triangle), and then remove the line itself by setting its pixel width to zero. Displaying the line usually gives the incorrect impression of a continuous trend, rather than displaying a discrete set of specific data points for comparison.