I have a line chart with a number of series. You know how if you mouse over
a line a tool tip shows showing the value, that tells me that excel can
detect the mouse over event over a line. Is it then possible to use this
capability to change the colour of the line whilt the mouse is over it? The
effect I am after is a glow when the mouse is over a particular line on the
chart.

Any help would be much appreciated as it will be a cool effect.

Kind regards, Mark Stephens

Mark -

Read my article on Chart Events:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Mark Stephens wrote:

I have a line chart with a number of series. You know how if you mouse over
a line a tool tip shows showing the value, that tells me that excel can
detect the mouse over event over a line. Is it then possible to use this
capability to change the colour of the line whilt the mouse is over it? The
effect I am after is a glow when the mouse is over a particular line on the
chart.

Any help would be much appreciated as it will be a cool effect.

Kind regards, Mark Stephens

Mark,

I tried to put something together but I'm not too thrilled with the
functionality. In any event, in addition to Jon's article maybe this can
help:

http://www.pdbook.com/index.php/exce..._a_line_chart/

--
Regards,
John Mansfield
http://www.pdbook.com


"Mark Stephens" wrote:

I have a line chart with a number of series. You know how if you mouse over
a line a tool tip shows showing the value, that tells me that excel can
detect the mouse over event over a line. Is it then possible to use this
capability to change the colour of the line whilt the mouse is over it? The
effect I am after is a glow when the mouse is over a particular line on the
chart.

Any help would be much appreciated as it will be a cool effect.

Kind regards, Mark Stephens

Mark,

Jon Peltier and Andy Pope have provided some further input on how the code
could be improved. These techniques work better that what I originally
posted. Please take a look at the comments related to this post:

http://www.pdbook.com/index.php/exce..._a_line_chart/

----------------------------
Regards,
John Mansfield
http://www.pdbook.com


"John Mansfield" wrote:

Mark,

I tried to put something together but I'm not too thrilled with the
functionality. In any event, in addition to Jon's article maybe this can
help:

http://www.pdbook.com/index.php/exce..._a_line_chart/

--
Regards,
John Mansfield
http://www.pdbook.com


"Mark Stephens" wrote:

I have a line chart with a number of series. You know how if you mouse over
a line a tool tip shows showing the value, that tells me that excel can
detect the mouse over event over a line. Is it then possible to use this
capability to change the colour of the line whilt the mouse is over it? The
effect I am after is a glow when the mouse is over a particular line on the
chart.

Any help would be much appreciated as it will be a cool effect.

Kind regards, Mark Stephens