How to create a Line Chart in Excel To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart.

Right now, the line chart doesn’t display the Emphasis series — the value $1,800,000 — as a vertical bar. It’s a round marker. The blue marker is there, but you can’t see it.

To get started, select the same data, B2:D8 and then choose Insert Combo Chart in the Charts group on the Insert tab. Choose a Clustered Column Line chart.