Creating Bounding Area Within XY Scatter Chart

< Back to Search results

 Category: [Excel]  Demo Available 

Creating Bounding Area Within XY Scatter Chart


Got a Excel Chart question? Use our FREE Excel Help!

This is a standard xy scatter chart. It has 2 data series plotted as markers only. The VBA code will then calculate the bounding area and output the necessary X and Y values in order to plot the encapsulating lines.

The technique for determining the bounding line is one known as 'gift wrapping'.

The lowest x value point is chosen as the Starting point and the each other point is checked to find the one that causes the smallest change in angle.


The example workbook contains the relevant class code to produce a set of bounding x and y values.
The animation property is purely for fun and demonstration.
There is also a property to to control how tight the bounding line fits the points. 
The example above is not a tight fit as the bounding lines are not touching the points.


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


See also:

Array Formulas - Excel Array Formulas
Assign Macros in Excel
AutoComplete for Data Validation List
Excel AutoFilter
Excel AutoFilters Custom Option
Excel AutoSum


Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

Extreme fetish video Shitting girls on the toilet and outdoors. Domination Scat mistress shit face slaves. All videos can be watched site ScatNude.com There are many categories on the site: Amateur Scat, BDSM Scat, Ebony Scat, Group Scat, Japan Scat, Lesbian Scat, Mature Scat, Scat Movies, Scat Sex, Scat Slave, Solo Scat, Toilet Scat. Have fun watching.


stars (0 Reviews)