How To Make A Line Graph In Excel

Today, I am going to share with you the step by step guide to make a line graph in excel in 2019 using the new and updated method.

Making a line graph in excel requires you to draw a line chart.

I will share with you the complete process in this single article to make a line graph using the line chart in excel.

Let’s start without further wasting your time:

  1. Open Microsoft Excel.
  2. Make a line chart.
  3. Put x-axis data in the left column and y-axis data in the right column.
  4. Enter your data in 2 columns(you can enter in more columns if you have more data).
  5. Select All The columns containing the data and click insert.
  6. Click on the line and it will show you the dropdown menu to select your own design for the line graph.
  7. I will personally prefer “Lines With Markers” but you can choose your own choice as there are 6 different types of charts.
  8. The line graph is created.
  9. It will change the values automatically when you will make any change in the columns.

Leave a Reply

Your email address will not be published. Required fields are marked *