desertsp
04-05-2017, 02:55 PM
I have an XY Scatter chart with hundreds of individual XY points. Each point is color coded (by a VBA macro) based on an adjacent column. These points represent elevations along a trail route (GPS data) and the color indicates the type of terrain (grassland, forest, etc.). See the attached sheet.
No matter how I format the XY point markers, I can't achieve a "continuous" look.
What I would like to achieve (conceptually):
1) Simplify the points into line segments. For instance, the uphill section between mile 6.2 and 7.3 could be represented by a single straight line rather than many individual points.
2) Color each line segment according to the predominant type of terrain between the start and end mile points. The line created in #1 would be colored green.
I hope that makes sense...the raw data is attached, along with a macro I currently use to color the points.
Can anyone recommend a scalable approach to this problem using Excel 2007 or 2010? I'll be reusing this for many similar datasets and plan to build a semi-automated solution.
Thanks!
No matter how I format the XY point markers, I can't achieve a "continuous" look.
What I would like to achieve (conceptually):
1) Simplify the points into line segments. For instance, the uphill section between mile 6.2 and 7.3 could be represented by a single straight line rather than many individual points.
2) Color each line segment according to the predominant type of terrain between the start and end mile points. The line created in #1 would be colored green.
I hope that makes sense...the raw data is attached, along with a macro I currently use to color the points.
Can anyone recommend a scalable approach to this problem using Excel 2007 or 2010? I'll be reusing this for many similar datasets and plan to build a semi-automated solution.
Thanks!