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

I have noticed numerous axis labelling errors in the student version of Excel
2007; forced reformatting of number values being among them. Label rounding
and placement errors also appear commonplace.

Does Microsoft have any Excel 2007 fixes on the way?



"Lala" wrote:

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?