LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.charting
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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP with Graphing. scott Charts and Charting in Excel 1 October 12th 06 11:31 PM
How do I find points on a curve between known points? Cybertori Excel Worksheet Functions 1 August 30th 06 07:57 PM
Graphing ace Charts and Charting in Excel 1 June 23rd 06 12:32 PM
graphing kristine Excel Discussion (Misc queries) 2 December 17th 05 05:12 AM
Graphing Metalteck Excel Discussion (Misc queries) 1 July 21st 05 08:39 PM


All times are GMT +1. The time now is 11:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"