+ Reply to Thread
Results 1 to 4 of 4

Is point inside the chart area or not

  1. #1
    Registered User
    Join Date
    09-13-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    2

    Is point inside the chart area or not

    Hi there,

    Here you can find my xy scatter chart attached. Also I have a macro which fills the polygon of series1. My question is that; Is there any way to determine a point(x,y) inside the polygon or not. User will input the x,y values and my excel will say it's in the area or not.

    Any help would really appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Is point inside the chart area or not

    Hi redblack
    stanysurfer has a good example of the code you require here http://www.excelforum.com/excel-prog...for-macro.html
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    09-13-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Is point inside the chart area or not

    yes, it's working great, thanks pike.

  4. #4
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: Is point inside the chart area or not

    Based on another recent topic.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1