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.

Excel offers a wide variety of charts and graphs, each designed to help you uniquely visualize data. But choosing the right chart isnt always straightforward.

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.

I just tried this. Select all the data you want to have graphed, click on Insert, pick line graph, and choose which one you want. Excel (2007) automagically grouped date and time on the X axis.