Re: Graphing points to the 10^-19
- From: "Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx>
- Date: Thu, 10 May 2007 22:57:39 -0300
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?
.
- Prev by Date: Re: Another Pivot Chart Autoformating Question
- Next by Date: Re: Error message when adding a name
- Previous by thread: Re: data series and axis labels
- Next by thread: Re: Graphing points to the 10^-19
- Index(es):
Relevant Pages
|
