Position floating chart in users field of view.

C

Chrisso

Hi All

I have a scorecard where each row reports on a metric. When a button
on a row is clicked I display a "floating" chart in the users field of
view. I have implemented my "floating" chart as follows:
* when not in use the chart lives underneath the print area so that
the user does not see it
* when the user clicks the row I feed the supporting chart data
sheet and position the chart

I am having trouble positioning the chart. I was going to position the
chart relative to the row clicked but have realised this is no good if
the row clicked is right at the bottom of the users screen. The chart
would be posiitoned mainly out of the users view.

Is there someway to work out how to position the chart so that it
always "floats" in the users field of view irrespective of where the
clicked row appears?

I have tried ActvieWindow Left and Top but to no avail.

Cheers for any ideas or tips.
Chrisso
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top