Calling all gurus! (this problem's a tough one! :) )

[Thomas]

Ok, seems to me that it should be possible to do this relatively easily, but the answer has thus far eluded me:

I have several process control charts that run for several months to several years at a time. When we have excursion points, we currently are writing comments next to the point in the database, but going through these is tedious. I've been asked to figure out a way to make the comments show as you mouse / click on the individual points, much like the X- and Y- values currently do.

Is this at all possible?

Thanks in advance ;
- Thomas

 

[PaddyD]

1) download the XY Chart labeller from
http://www.appspro.com
2) check out what it does
3) smile as the solution emerges, or
4) post back complaining about the garden path I just sent you up!

Paddy
This message was edited by PaddyD on 2002-09-18 16:18

 

[Thomas]

PaddyD -

That is a great tool, but isn't quite what I was looking for. With the number of datapoints that are charted at any given time, by showing these labels at one time, the chart becomes unreadable! .

Looks like the creator of this has done something with pointing the Data Labels at a specific range; the question is whether it may be possible to do this with a mouse-over action. Even if this was something like a 'Whats This' function or a 'HelpContextID'... any such thing would work here.

Thanks again;
- Thomas

 

[PaddyD]

Looks like you'll need a VBA methos to interact with the chart - not the sort of thing I do, but plenty of great VBA coders here...

Paddy