What are Line Charts in Excel?

A line chart is a graph that shows a series of data points connected by straight lines. It is a graphical object used to represent the data in your Excel spreadsheet. You can use a line chart when: You want to show a trend over time (such as days, months, or years).

  1. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a line chart. …
  2. Select the data that you want to plot in the line chart.
  3. Click the Insert tab, and then click Insert Line or Area Chart.
  4. Click Line with Markers.