Sunday, 21 July 2013

Create A Graph For Data In Excel Worksheet.

Here We Learn To Create A Simple Graph In Excel Worksheet:-

This Can Be Achieve In Some Steps:-
1)Open the Ms_excel.
2)Prepare the data which is required ,in two columns for with respect to X-axis and Y-axis.
3)After the data entry ,go to 'Insert Tab' and select 'Line' as shown in picture.                                                          
                
4)The new dialog box is appear ,Just delete it's lines and texts for entering your new lines (for
   data ) and text.
5)After that go to 'Design' Tab (It appear after select 'Line'), select 'Select Data'.
6)Open a new Dialog box.Where we select the data for X-axis(Horizontal) and Y-axis(Vertical).
                       
7)Select the data from columns. Here Above red line is for Vertical data and below is for 
   horizontal data, blue circle is input data.For Horizontal click 'Edit' open a new dialog box,Enter the 
   range in text box and click on 'Ok'.
8)Your graph is prepared-





No comments:

Post a Comment