Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP with Graphing. | Charts and Charting in Excel | |||
How do I find points on a curve between known points? | Excel Worksheet Functions | |||
Graphing | Charts and Charting in Excel | |||
graphing | Excel Discussion (Misc queries) | |||
Graphing | Excel Discussion (Misc queries) |