Re: Graphing points to the 10^-19
- From: "Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx>
- Date: Fri, 11 May 2007 09:11:03 -0300
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" <Lala@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BBBD75D9-D132-47FF-9BBC-2F4E5D98107F@xxxxxxxxxxxxxxxx
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" <Lala@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:972F4E9D-ACB5-4371-BE51-48541F2D5B2B@xxxxxxxxxxxxxxxx
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?
.
- Follow-Ups:
- Re: Graphing points to the 10^-19
- From: Lala
- Re: Graphing points to the 10^-19
- From: Jon Peltier
- Re: Graphing points to the 10^-19
- References:
- Re: Graphing points to the 10^-19
- From: Bernard Liengme
- Re: Graphing points to the 10^-19
- Prev by Date: Re: data series and axis labels
- Next by Date: Re: Graphing points to the 10^-19
- Previous by thread: Re: Graphing points to the 10^-19
- Next by thread: Re: Graphing points to the 10^-19
- Index(es):
Relevant Pages
|
