im not too experienced in drawing graphs in excel. here is what im
trying to do.

y-axis:
100 - 0, at increments of 10

0.000 000.0
0.092 004.3 003 008
0.126 005.0
0.172 008.0
0.216 016.0
0.287 021.0
0.392 030.0 029 049
0.536 041.0
0.643 065.0
0.732 084.0 000 089
0.879 099.0 090 100
1.000 100.0 100
1.200 100.0
1.366 100.0

PROBLEM 1: i want to have a gridline at every x-value (column 1), not
at some scaled amount.

PROBLEM 2: i want to draw a line from 100 to 0, making a perfect
diagonal line.

PROBLEM 3: i want to draw points, not lines, that correspond with the
x-axis (column 3)

i dont have trouble graphing 1 line, but i dont know how to solve these
more advanced problems.


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=392348

i've solved every problem but problem 1. how do i draw a line at every
x value rather than at a scaled value.


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=392348

To me, the easiest solution involves creating "dummy" several series for
these vertical "gridlines." Somewhere in your spreadsheet put a formula
or hand enter each X value, then duplicate it in the cell immediately
below. Then in the column next to these two cells, put the values 0
and 100 and plot these two points as a dummy series formatted how you'd
like the "gridline" to appear.

Did that make sense?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=392348

for some reason, when i try to plot it using x value = 1 and y value =
0,100, instead of a straight line up and down i get a diagonal line. i
am using a xy scatter chart with smooth lines.


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=392348

Can you get one point where you want the vertical line, say at the
bottom of the chart? Then use a vertical error bar for your gridline.
See this web page for details:

http://peltiertech.com/Excel/Charts/...Gridlines.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


lsu-i-like wrote:

for some reason, when i try to plot it using x value = 1 and y value =
0,100, instead of a straight line up and down i get a diagonal line. i
am using a xy scatter chart with smooth lines.

ok, i was able to make the x-value lines appear using the vertical error
line method. now i would like to get the corresponding x-values to
appear on the x-axis.


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=392348

Use data labels on the points you added (the points with the vertical
error bars). The labels should be positioned below the points, and
should show the category values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


lsu-i-like wrote:

ok, i was able to make the x-value lines appear using the vertical error
line method. now i would like to get the corresponding x-values to
appear on the x-axis.