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.

Edit your horizontal chart data in Excel 2007 with a variety of available tools. Change the data, format, titles and scale of your scatterplot's horizontal axis.

Numeric variables will always result in number-based responses, which are represented in scatter or line charts with continuous values.

In Microsoft Excel, to draw attention to a specific marker in a line chart, drop in a thin line, think of it as a marker.