ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-01-2005, 01:06 PM
Mark Stephens
Guest
 
Posts: n/a
Mouse over effect, anyone know how to do it?

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


Reply With Quote
  #2  
Old 05-02-2005, 10:06 PM
Jon Peltier
Guest
 
Posts: n/a
Re: Mouse over effect, anyone know how to do it?

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
>
>


Reply With Quote
  #3  
Old 05-03-2005, 04:06 PM
John Mansfield
Guest
 
Posts: n/a
RE: Mouse over effect, anyone know how to do it?

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
>
>
>

Reply With Quote
  #4  
Old 05-04-2005, 10:06 AM
John Mansfield
Guest
 
Posts: n/a
RE: Mouse over effect, anyone know how to do it?

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
> >
> >
> >

Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 10:29 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0