Changed y scale min and maxt to fixed, thinking that might help, when nothing
happened changed it back to automatic. As for the numbers being small. The
graph was supppose to give me the Rydberg constant (from the slope) based on
a spectroscopy reading of a hydrogen light.

Thanks for all the help and giving me the full y formula values. The other
post about excel just assuming that any number smaller than 10^-10 is 0
answered my main question about the disappearing y values.

"Bernard Liengme" wrote:

I had no trouble getting a chart with your data. The slope is -2.35E-18 and
intercept 5.49E-19
Since your cells have entries such as =2.872*10^-19 which display as
2.872E-19, it would appear you have real numbers and not text. A bit of a
mystery!

You have not set the y scale min & max to anything other than 'automatic'
have you?

Have you tried a new workbook entering values like this
x y
1 1E-10
2 2E-10
3 3E-10
4 4E-10
can you get a chart with these values?


By the way: if I was working with numbers like yours (but as a scientist I
cannot think of anything that small that I could measure!) I would use
x = 0.1111 y= 2.872
x = 0.0625 y= 4.043
x = 0.0400 y= 4.576
x = 0.0277 y= 4.814
Then I would scale the resulting slope and intercept by a factor of 10^-19

"Lala" wrote in message
...
Yes the graph choosen is the xy scatter graph. The values I'm trying to
graph
are :
x = 0.1111 y= 2.872*10^-19 ; (2.872E-19 when actually posting in the cell)
x = 0.0625 y= 4.043*10^-19 ; (4.043E-19)
x = 0.0400 y= 4.576*10^-19 ; (4.576E-19)
x = 0.0277 y= 4.814*10^-19 ; (4.814E-19)

Again the Y values of (1E-19 to 6E-19) are not posting, only 0 value is
posting.
When editing the y axis the minimum value on automatic is 0 and the
maximum
does say 6.0E-19. But on the actual agraph I don't see these values. So
when
doing a line graph I only get a linear equation of y=5E-19 instead of
y=mx+b.

Excel does graph the data points and when adding data labels, the values
appear. It's just the division values (1.00E-19 to 6.00E-19) on the y axis
that doesn't appear.

I've also tried setting the cells to scientific numbers, general and
numbers
but that didn't help.

It has to be the program because I've had 2 people graph my data and it
worked on their software.