ShelleyBelly
New Member
- Joined
- Mar 2, 2011
- Messages
- 44
Hello Everyone,
Many thanks in advance. I have an issue where by a data set on a XY scatter graph is joined with Linear Trend line. It is used to show the routes a ship takes and the scatter graph has a map as a back drop, x axis is longitude and y is latitude.
The longitude (x axis) starts at -180 (west) to +180 (east).
Now the problem is when i make a route (trend line) that heads east from the eastern side, and exceeds +180 i'd like the route to the trend line to go up to +180 and then continue from -180 on the same latitude. The same goes for heading west in the western hemisphere passing -180.
At the moment the trend line draws right across the entire graph. A good example would be heading from Hawaii to Australia which would mean heading west, but at the moment it draws all the way across the globe eastwards, which not the actual route that would be taken.
essentially the x axis should almost be consider continuous ending at is maximum but then starting immediately from minimum again at the same y axis value.
I hope this makes sense.
I could ofcourse place intermediate xy data points at +180 and -180 to give the appearance of the trend line exceeding the max x value before starting again from the minimum and vice versa, but if there is a way in VBA then i think this would be a cleaner and more useable solution for all.
Many Thanks in advance,
Tom
Many thanks in advance. I have an issue where by a data set on a XY scatter graph is joined with Linear Trend line. It is used to show the routes a ship takes and the scatter graph has a map as a back drop, x axis is longitude and y is latitude.
The longitude (x axis) starts at -180 (west) to +180 (east).
Now the problem is when i make a route (trend line) that heads east from the eastern side, and exceeds +180 i'd like the route to the trend line to go up to +180 and then continue from -180 on the same latitude. The same goes for heading west in the western hemisphere passing -180.
At the moment the trend line draws right across the entire graph. A good example would be heading from Hawaii to Australia which would mean heading west, but at the moment it draws all the way across the globe eastwards, which not the actual route that would be taken.
essentially the x axis should almost be consider continuous ending at is maximum but then starting immediately from minimum again at the same y axis value.
I hope this makes sense.
I could ofcourse place intermediate xy data points at +180 and -180 to give the appearance of the trend line exceeding the max x value before starting again from the minimum and vice versa, but if there is a way in VBA then i think this would be a cleaner and more useable solution for all.
Many Thanks in advance,
Tom
Last edited:
