Excel Effects

Column and scatter line chart – Compare years or periods using the bars and the line to form an analysis.

Column scatter line chart

Column chart with scatter line

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.

Download


Chart library

Development Category (English)300x250

Microsoft Surface Book 3

Microsoft