View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Graphing points to the 10^-19

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?