How to Make a Line Graph in Microsoft Excel

How to Make a  Line Graph in Microsoft Excel

Microsoft's Excel program allows you to build spreadsheets with mathematical formulas that adjust data according to your instructions on an ongoing basis.

 

        A Line graph is a graph based on numerical data that allows you to show proportions in a Line Graph.

You can learn how to make a Line Graph in Excel and modify it for your report or presentation.In the line Graph the X-axis represents the passage of time, and the Y-axis tracks the datapoints

Open Microsoft Excel on your Computer.

 

     1. Click On :New" at the left side

     2. And click on the "Create" button at the Rightside

Enter information and Data in the cells that you will use.

 

Enter your time that you Spend  in 24hrs (1440min) in different activity such is

Sleeping Time + (20min)Other Activity

Working Time

Pray Time

Eating Time

and Tea Time

Mostly its depend on your daily lifestyle, You  can  inter them in your manner i only suggest them.

Enter the time you spend in 24 hrs.

 type the formula =C2/B2in cell D2 and hit Enter.when you will do this,Excel will automatically.

 

 Press Enter.

Format your cells in the column according to whether they are.

words  numbers, Date, Time, Percentage, Currency, Fraction, Scientific, Text, Special and Custom,

Highlight a group of cells by clicking on 1 cell and dragging it with your mouse until you've covered all the desired cells. You can also click on the letter at the top of the column or number at the row, to select an entire column or row.

Right click on the selected cells and click "Format Cells".

Click On “Percentage” to indicate what value you will want to ADD .

Click OK
And then the value should be convert to the percentage value.

Look for the small box with a plus(+) sign that pops up near the bottom of those cells. Click the arrow and choose "Fill Formatting Only." This will copy the type of formula you have just used, but move the values to the correct vertical row.

Select the data that you would like to use in the Line Graph. Use your mouse cursor and drag it over both columns and all the rows that are included. Make sure it does not highlight a separate data series.

Now You two step away to stand a Line Graph  in Excel.

1. Click on the Insert that i Highlighted.
2. and Then Click on the Line.


there is also other type of Line Graph which is   2-D line, 3-D Line Graph  etc .

 

 Press"OK". 

Also Read Other Related Post: 

1. How To Make Area Graph in Microsoft Excel
2. How To Make Line Graph in Microsoft Excel 
3. How To Make Bar Graph in Microsoft Excel
4. How To Make Pie Chart/Graph in Microsoft Excel.