Back
Create a Line Chart - Excel on a Computer

Line charts can illustrate what are called data series. A data series is a group of data with similar characteristics. They can be in rows or columns. Below, you can see two series of data in columns: (a) dates, (b): sales numbers. Both data series have a title (Date, Sales).

  1. Highlight cells C1 to D11. We do not include cell D12 because it is not part of a series. It does not contain a sales number for a certain date.
Callout number one is pointing at the range of cells selected under the columns for Date and Sales.



  1. Click the "Insert" ribbon to see that ribbon. A ribbon is a menu.
  2. Click "Line" from the Charts menu.
  3. Click the first 2D line chart that appears.

Callout number one is pointing at the Insert menu. Callout number two is pointing at the Line option from the Charts menu. Callout number three is pointing at the first option under the 2-D Line.



  1. You may optionally add axis titles. To do this, click on the chart, then click the "Chart" ribbon to see that menu.
  2. In the "Labels" submenu, click "Axis Titles"
  3. Click "Primary Horizontal Axis Title" then "Title Below Axis."
  4. Enter "Dates" for the primary horizontal axis title.
  5. Click "OK." Repeat steps 2-5 for the primary vertical axis. You can use the "Rotated Title" style and "Dollars" for the label.

Callout number one is pointing at the Chart menu and the Sales chart. Callout number two is pointing at the Axis Titles option under the Chart menu. Callout number three is pointing at the Primary Horizontal Axis Title and the Title Below Axis option. Callout number four is pointing at the Title text that can be edited. Callout number five is pointing at the OK button for the Edit Title pop up window.



  1. Click, hold, and drag the chart to position it below cell D12.
Callout number one is pointing at the arrow that follow the Sales chart. This shows that you can drag the chart any where in the spreadsheet.