Friday, June 26, 2015

How to Draw the graph in Ms Excel

First we enter the data now draw graph on the Percentage values



Click on the insert tab as picture show
select percentage column as below picture shown


Click on the column graph 


Click on the 2-D column first graph


Graph will as shown Picture 


Click on the X axis  where 1   2    3     4   5 as figure shown


           Right click on the select area and click on select option as figure shown


                                         Click on the edit button which is point by aero 


            Select English Chemistry Physics Biology Mathes by mouse and click Ok button as below Picture Shown


         Click OK button as shown in the figure below 


Now graph will show with subject name as Picture shown below


           In this Post we learnt about how graph draw on the excel sheet 


No comments:

Post a Comment