(2) How to make a Line Graph in excel.
Following is the example of a Line Graph:
Following are the step by step procedure of How to make a Line Graph in excel:
(i) Open excel file. Input your data. Click to a blank cell. Now click to Insert tab & click to Line.
(ii) Mouse right click to the blank graph. Click to the Select Data.
(iii) From Legend Entries (Series) click to Add.
(iv) Write the Series name. Select the Series values. Than click OK.
(v) From Horizontal (Category) Axis Labels click to Edit.
(vi) Selec the Axis label range. Than click OK.
(vii) Click to OK.
(viii) Write click on a Line and select Add Data Labels to add data on top every line.
Video:
How to make a Line Graph in excel:
|