Using excel to plot graph

[gjpollitt]

Anyone know how to define a chart that has x,y axis in excel?

I want to plot a chart of voltage over current on forward characteristics of a diode but I can only get the graph to display one axis ie the x axis is 0, 1, 2 ,3 etc setup by excel but I want to link the x axis to the voltage of my table and the same with the y for current

I cant find the option for setting up both the x and y axis

thanks
graham

 

[fsahmed]

Put the values u want on X axis in columnt A, Y axis in Column B. then select the two columns, click on graph & in the graph options, select "XY SCATTER".

 

[gjpollitt]

thanks, I was using the line graph with only 1 axis configurable