Hi Jon,
Yes, I overlooked the mention of 2007! But as I said to OP, if is hard to
imagine a use of such small numbers and a y-axis transformation will work
even in XL2007. As you know better than I, MS have been trying hard to avoid
the 'nasty' tiny numbers that should be zero but are not because of 'binary
round off errors'. We getting fewer questions about that topic with XL2003
becoming more popular. So I cannot fault MS too much on this score!
Cheers
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jon Peltier" wrote in message
...
The secret was in the OP's first line:

I have the home and student 2007 version.

Microsoft has "improved" their treatment of tiny rounding errors by
arbitrarily assuming certain small values are really supposed to be zero.
The ignored values are less then or around 1E-15, which corresponds to the
missing values in my testing (see my other post). This has messed up the
trendline regression formula, which used to be considered the best in the
business.

LINEST calculates the regression coefficients properly, at least in 2003
and 2007 (I didn't bother to test prior to this).

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


"Bernard Liengme" wrote in message
...
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?

What do you get with =SLOPE(B2:B5, A2:A5) - the B range holds the
y-values, A range the x-values. ?

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

Happy to look at a file if you send me one to my private email (not
newsgroup)
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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.

"Bernard Liengme" wrote:

It would be helpful to see at least 5 data points (both the x and the y
values): could you list them for us?
Are you sure you have made an XY chart and not a Line chart?
If you wish you may send me a file with the data
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lala" wrote in message
...
I have the home and student 2007 version. When graphing a scatter
graph
with
the Y axis having 10 to the negative power, excel doesn't show the
values
on
the y axis. It only shows the 0 intercept value. I've tried editing
the
axis
values but the number still doesn't display and excel automatically
puts
the
number to at least 10 decimal places, ie 5.000000000000001E-19.

When I just click automatic, the right values appear in the edit menu
but
the y values still won't show on the actual graph. So when doing a
trendline
the equation doesn't show an m slope value, ie y=5E-19. A friend
graphed
my
data on an older version excel and it graphed it properly with the
proper
y
values displaying, and linear trendline equation was in right format
of y
=
mx + b, ie y= -2E-18x + 5E-19

Could my software be defective? Or are some features disabled?