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...
--
Phil

Looks like another irregularity in Excel 2007 charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Philippe" wrote in message
...
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...
--
Phil