Can Contents Of Chart Tooltip Be Modified?

[Mike Wignall]

Hi All -

Background:

XL2K SR-1. I'm trying to work out how to change the default set of
info that a tooltip presents when the mouse cursor is placed over an
individual data point in a chart.

Example:

Lets say we have a stock HLC type chart that present 3 data series
plotted againts dates. The chart legend will provide the info that
Series 1, 2 & 3 are plotted in the chart, but I want it turned off to
save space.

The tooltip will present the info in the format, say :

Series 1 Point "01/17/2002" Value 176
and
Series 2 Point "01/17/2002" Value 160
and
Series 3 Point "01/17/2002" Value 166

when the mouse cursor is moved over the data marker for Jan. 17, 2002.

The problem is that if the Hi - Lo data marker is small it is not
clear from visual inspection that Series 1 represents the Hi, Series
2 the Lo and Series 3 the Close values.

Question:

Is there some way that the "Series n" field in the tooltip can be made
to say *specifically* what it represents? Thus the above tooltip e.g.
would end up as:

High Price Point "01/17/2002" Value 176
and
Low Price Point "01/17/2002" Value 160
and
Close Price Point "01/17/2002" Value 166

I suppose it comes down to somehow getting the tooltip to call up the
data column headers rather than simply defaulting to addressing the
data in each column as being Series 1, 2 & 3. If anyone can suggest a
solution I'd be most grateful.

- -
Mike
London, UK

[Jon Peltier]

Mike -

I have a couple of routines on my web site that you might find
useful. I'd heard from the experts that you couldn't change the
ToolTips (and these are folks who could hack into the actual tool
tips rectangle window if it were possible), so I went to chart
events. These tell you point information if you click on a point,
but you could link the info to a mouse over instead of a mouse up,
and you could display the information in the statusbar or somewhere,
rather than in a message box that halts everything.

Check out this link:
http://www.geocities.com/jonpeltier/Excel/Charts/index.html#PointInfo

Good luck,
- Jon
_______

In article <3c4b0ff4...@news.blueyonder.co.uk>,
wig...@blueyonder.co.uk says...

[Victor Eldridge]

Unfortunately there is no way to edit Excel's chart tips. You can however,
use VBA to simulate the feature, although it is by no means a simple task.
There's some code on the following webpage, that shows one way of doing it.
http://www.j-walk.com/ss/excel/eee/eee006.txt
There are directions there that explain how to set it up, however there is
one thing missing from those directions, ie. If you copy the code to a
brand new workbook, you need to save the workbook first.

HTH,
v...@ultratrace.com.au

"Mike Wignall" <wig...@blueyonder.co.uk> wrote in message
news:3c4b0ff4...@news.blueyonder.co.uk...

[Mike Wignall]

Hi Jon and Victor -

Many thanks for your suggestions. I'll chase them up.