Hi everyone,

Been looking around for some ideas on how to execute a navigation idea. The
application I am building is for trading and draws a chart in real time for
the trader but of course as time progresses the chart moves right and up (or
down depending on where the market's going).

What I want to do is to insert a fixed size, embedded dynamic chart (a
thumnail if you like) on the page which the user can click and drag his
mouse over the navigate the large chart above. WHen I say chart it is not
actually a chart, well not a built in excel chart, but one I am creating by
inserting o or x in the cells to create the illusion of a chart (axes etc
are drawn in).

I was looking on John Walkebach's site:
http://j-walk.com/ss/excel/tips/tip41.htm where he shows how to do an image
map and it strikes me that the ability to track the mouse when it is held
down rather than clicked is what I need. If it is a chart that is clicked
however then chart elements will be selected which i don't want, I could
cover it with and autoshape of the same size and track it over that would
that be the best bet do you think?

Another ([erhaps preferable option) would be to let the user simply drag his
mouse over the sheet to navigate the chart (perhaps with the small thumbnail
chart as a navigational reference so he can see where the 'chart' is going
(in terms of up or down). Ideally I would like for the user to be able to
simply drag left or right over the chart and it would automatically scroll
up or down to follow the density of the o's and x's (probably use 'used
range' between certain columns if the is possible).

I am not sure how clearly I have articulated my requirements so apolgies if
it is not a sclear as I think and don't hesitate to ask me for more info if
needed.

Thanks and regards, Mark

PS It is bedtime here in Singapore so I will be opening the user group again
in about 8 hours, until then...zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz