drawing a graph

L

lsu-i-like

im not too experienced in drawing graphs in excel. here is what i
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), no
at some scaled amount.

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

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

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

lsu-i-like

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

MrShorty

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

Did that make sense
 
L

lsu-i-like

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.
am using a xy scatter chart with smooth lines
 
L

lsu-i-like

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

Jon Peltier

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/
_______
 
Top