Page 1 of 1

Excel question

Posted: Sat Feb 05, 2005 3:16 pm
by Vindicator
I have the following set of data:

Code: Select all

Volts   P (mm)
0       0
3       1.5
6       4
9       5
12      6.5
15      8
18      10
21      11.5
24      13.5
27      15
30      16.5
This is what the graph tool is spitting out at me.

Image

I want the volts (0-30) on the bottom and the P (0-18) on the y axis. How can I fix this? TIA.

Posted: Sat Feb 05, 2005 3:46 pm
by Lothar
right-click the chart. Click "source data". Click the "series" tab.

Where it says "x-axis labels", select the data for "volts". Where it says "series", remove the one for volts, and leave the one that has your p data... thusly

Image

Posted: Sat Feb 05, 2005 4:00 pm
by Vindicator
Awesome, thank you.

Posted: Mon Feb 07, 2005 9:34 am
by Iceman
Next time just select the two data columns, click the chart wizard, select "XY (Scatter)" and pick a graph type with connected scatter points.