(3) How to make a Line Graph with two or more series in excel.
Following is the example of a Line Graph with two series:
Following are the step by step procedure of How to make a Line Graph with two series in excel:
Step-1: Open excel file. Input your data. Click to a blank cell. Now click to Insert tab & click to Line.
Step-2: Mouse right click to the blank graph. Click to the Select Data.
Step-3: From Legend Entries (Series) click to Add.
Step-4: Write the Series name. Select the Series Values. Than click OK.
Step-5: Again click to Add.
Step-6: Again write the Series name. Select the Series values. Than click OK.
Step-7: From Horizontal (Category) Axis Labels click to Edit.
Step-8: Select the Axis label range. Than click OK.
Step-9: Click to OK.
Step-10: Write click on a Line and select Add Data Labels to add data on top every Line.
Video:
How to make a Line Graph with two or more series in excel:
|