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.
Column Chart and Scatter Line Chart for Excel
Click on the link below to download this chart. Keep in mind, it requires Excel 2007 or higher or compatible.
Questions or Comments
Email us at firstname.lastname@example.org with any questions or comments.