How to Make an Area Graph in Excel

How to Make an  Area Graph in Excel

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

 

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 Area 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 an Area Graph  in Excel.

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


there is also other type of Area Graph which is   2-D Area and 3-D Area Graph  etc .

 

or

 

 Press"OK".to see the Result.

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.