View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Chart display problem when changing axis minimum/maximum

Yes Eric, I also replicate your observations with different aspect ratios,
square looks right!

Regards,
Peter T

"EricG" wrote in message
...
I was able to re-create your issue. I'm running 2003 (11.8307.8221) SP3.
I
did find that by manipulating the aspect ratio of the plot area to be
sqaure,
I could force the line through the (0.999,0.999) point! If the plot area
is
wider than it is tall, then the line moves to the right on the x-axis. If
the plot area is taller than it is wide, the line crawls up the y-axis.

That's either a bug or a feature, but it certainly isn't normal!

Eric


"Peter" wrote:

I encounter this problem both in Excel 2003 and Excel 2007:

I created a simple scatter chart with lines, with only two datapoints:

x y
0 0
1 1

This gives a correct chart with a straight line through {0,0} and {1,1}.

The problem occurs when I change the axis minimum of both axes to 0.999.

Excel should display a chart with a straight line through {0.999,0.999}
and
{1,1}. But it does not. The line is crossing the x-axis somewhere around
0.9994 (different exact value in both Excel versions).

Can I solve this problem with changing Excel settings or would this be
caused by a bug in the software?