-
20th August 2005 07:35 AM #1
Using excel to plot graph
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
-
20th August 2005 07:40 AM #2
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".
-
20th August 2005 08:41 AM #3
thanks, I was using the line graph with only 1 axis configurable