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.
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