View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jonathan Davis Jonathan Davis is offline
external usenet poster
 
Posts: 3
Default Excel Graph Click Problem

Greg,

First of all, Thank you *very* much for your help so far. No one else
has reponded in 5 other forums that I have posted to.

Now, to bugging you once again. This code does *almost* everything that
I need. The only problem is I am not using an embedded chart, and hence
your equation for xVal and yVal do not take into account the grey space
surrounding the chart. I know this is the problem because I have moved
the chart to the top/left of the screen (not showing any grey space) and
the scaling worked perfectly, yet in any other position the scaling is
off by a set amount. This would be an easy fix if this were an embedded
chart by using the chartObject object, but since this is not an embedded
chart, I don't know how to get the .top and .left values.

Thank you *very* much for your help so far. With this last answered, I
could put this project to rest.

Jonathan Davis

*** Sent via Developersdex http://www.developersdex.com ***