Column and scatter line chart – Compare years or periods using the bars and the line to form an analysis.
Firstly, you do not always get data labels with a column chart and scatter line chart. Secondly, we scaled the number of columns down a bit. Basically, with this chart, you can look at certain years or periods using the bars and the line to form an analysis.
So, we put the vertical bars on the primary axis. It is separate from the line. And, on the other side, is the scatter line.
Click on the link below to download this chart. Keep in mind, it requires Excel 2007 or higher or compatible.