create-simple-x-y-chart-based-on-2-columns-of-data

In an, experiment or in any relational quantitative analysis, we often require to do annalysis via graphical tool and to set few strategy to get required  output or to show process parameters.

This article describes how to create relational graph X-Y graph in excel
X- value : Parameter and Y- Value : Another Parameter. and Not Numericals as in LINE GRAPH

Step 1:

Enter the data in the cells of an Excel spreadsheet, like this: 

 

 

Step 2:Use the mouse to highlight the block of cells containing your data, then click the Chart Wizard button (illustrated in Step 1 in the passage on Bar Graphs).

 

 

Step 3:

Choose the XY (Scatter) chart. Usually the best subtype is the one in which individual data points are connected with a line, as shown on the following page.As soon as you click on specific graph it will show you graph.


**Pay attention!** The Line graph choice looks tempting, but don’t be fooled. Excel’s Line graph will NOT consider the relative values of the numbers on your X axis! In our example, the X-axis values are 100, 200, 500, and 1000. If you choose Line, you will get those numbers equally spaced. If you pick XY (Scatter), as you should, Excel will create a graph in which 1000 is ten times as far away from 0 as 100 is. If you don’t believe me, try both graph types with the data I have given you, and look at the difference.





You may change the axis by right click on the graph and clicking on Select Data. 




You may select different horizontal axis for both graphs.

Happy Annaylzing.