+ Reply to Thread
Results 1 to 3 of 3

Dynamic Shapes on Chart

  1. #1
    Registered User
    Join Date
    03-03-2015
    Location
    MN, USA
    MS-Off Ver
    2010
    Posts
    4

    Dynamic Shapes on Chart

    New guy here, so please go easy on me. I'm working on a project that could use two perpendicular lines to follow the cursor around on a chart. I've gotten it to work to a point, but my problem lies in what I believe to be the scaling of the PlotArea. I define the start/end of both lines as the boundaries of the PlotArea, but it is evident that they don't start directly on the boundaries. Also, as the cursor moves down and to the right, the discrepancy between the cursor and the intersection point of the perpendicular lines becomes larger. What I want to find out is how to make the two lines perfectly "in sync" with the cursor and the PlotArea boundaries. The conceptual workbook is attached in case anyone would want to take a look. Thanks in advance!

    My code is placed in the Chart's sheet.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by senuba91; 03-10-2015 at 09:33 AM. Reason: Cleaned up workbook code and layout

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,079

    Re: Dynamic Shapes on Chart

    The shape x and y values are on a different scale to the mouse x and y values.

    try adding a fudge factor
    Please Login or Register  to view this content.
    But it's more complicated than that as zoom setting has an affect.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-03-2015
    Location
    MN, USA
    MS-Off Ver
    2010
    Posts
    4

    Re: Dynamic Shapes on Chart

    That's made a considerable improvement at a magnification of 100%. I think at this point it'll just take setting up some scenarios to accurately gauge the relationship between zoom factor, shape scaling, and mouse scaling. Thanks, Pope!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Advanced bubble chart shapes
    By mmedeny in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-21-2013, 08:51 PM
  2. Replies: 5
    Last Post: 12-06-2012, 06:52 PM
  3. enabling dynamic shapes
    By patrickmcdevitt in forum Excel General
    Replies: 2
    Last Post: 06-11-2012, 01:55 PM
  4. scrolling chart with shapes that scroll also??
    By mkbanister in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-27-2009, 09:11 AM
  5. [SOLVED] shapes caption on chart
    By nk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2005, 12:06 PM

Tags for this Thread

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