how to make a line graph in excel simple steps | 2022

MS Excel is a spreadsheet which is made by Microsoft Which helps us in different things as you get the features of table creating, graphing tools and different designing here you can create a lot. 

Friends, today the topic about which I am going to tell you is How to make a line graph in Excel. I will tell you in this article in a very easy way how you can do this create. I will explain you better I hope you will definitely take advantage of this information.

How to insert line graph in excel Steps

Now let's talk about the topic, which I am going to tell you If you don't know how many types of the graph. The most commonly used graphs table is a column, Line, Pie, Bar, Area, Scatter graphs, and others.

Now I will tell you step by step how you will be able to create a line graph in ms excel then you have to follow my instructions carefully.

• First of all, you have to open MS Excel on your computer or laptop, that is, keep the spreadsheet open. 
• After that, the work you have to do is that you have to type the data that you want to show in the line graphs. 
• After that, you will get to see a menu at the top, in which you have to click on Insert. 
• After clicking on insert, you will see a box with a chart there, you will also get to see written graphs types. 
• Now, you will get to see a format which line, you have to click on it.
• After clicking, you have to select the shape you want to place your line graph there. 
• After that, if you want to show the data that you typed, then select it and put it in the graph. 
• After this, you will see that data will start showing in your graph.
• After that, if you want to edit or change the data, then you have to right-click on the graphs and click on select data. 
• A small box with Select Data Source will open in front of you. in which two sides will be made one One type data horizontally and one to type data vertically.
• After that you can click on edit, if you want to do it vertically then do it vertically, if you want to do it horizontally, after clicking you have to select the data you want to show and click ok.

Frequently asked questions

How to Make an X Y line graphs in excel?

 What I have told you step by step above, is called an x-y line graph. You will be able to draw graphs in XY easily by reading the steps.

Can you graph a line in Excel?

Simply you have to click on >insert>click on line>select formate & put data which you write for line graphs.

Conclusion: In this article, I try to tell you about creating line graphs on an ms excel spreadsheet in a very easy way step by step. If you like it then you can share this information with your friends and relatives.

And also if you have any problem and any query about this topic tell me in a comment below I will definitely reply to you.