Is that a bug in Excel 2007 ? Wrong automatic range for negative v

P

Philippe

Hello,

I am building XY charts of coordinates (in decimal degrees) in Excel , to
show a GPS track.

When the coordinates values are negative, I have no problem with Excel 2000
or 2003, the automatic range for X and Y axis is defined correctly, and I can
see my track perfectly.

With Excel 2007 and negative coordinates values, the automatic range
selected by Excel for the axis is much too large, and my GPS track is showed
as a few dots at the center of the chart. The values of MinimumRange and
MaximumRange are not coherent with the value of MajorUnit.

Here is an example of a dataset that graphs correctly in Excel 2003, and
wrongly in Excel 2007

Longitude (º) Latitude (º)
-77.0001 -4.0003
-77.0003 -4.0004
-77.0008 -4.0006

Any help or suggestion would be appreciated. I suppose that once again I'll
have to write a patch for my users that work with Office 2007...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top