I was wondering if anyone knows a way to change the "chart tip" that
pops up when you move the mouse over a slice of a pie chart. I want to
be able to customize the contests of the tip that pops up.


Assume for a moment that you have enabled "names" and
"values" (Tools---Options--- Chart and check the two boxes under
chart tips). When I move the mouse over a pie slice a floating box
will pop up that says:
Series 1 Point "xxxxx"
Value: xx (yy%)

I would like to be able to customize these chart tips.

Thanks.

Mike

Check out the Auto Hover utility on Tushar Mehta's site,
http://tushar-mehta.com

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


wrote in message
ups.com...
I was wondering if anyone knows a way to change the "chart tip" that
pops up when you move the mouse over a slice of a pie chart. I want to
be able to customize the contests of the tip that pops up.


Assume for a moment that you have enabled "names" and
"values" (Tools---Options--- Chart and check the two boxes under
chart tips). When I move the mouse over a pie slice a floating box
will pop up that says:
Series 1 Point "xxxxx"
Value: xx (yy%)

I would like to be able to customize these chart tips.

Thanks.

Mike

This can be done with VBA, in fact I think this is one of those situation
inwhich you actually have a need for a Class Module.

You can check out John Walkenbach's site or Power Programming book for hint
on how to work with class modules.

However, if you are trying for a none VBA approach I think you are out of
luck.

Cheers,
Shane

wrote in message
ups.com...
I was wondering if anyone knows a way to change the "chart tip" that
pops up when you move the mouse over a slice of a pie chart. I want to
be able to customize the contests of the tip that pops up.


Assume for a moment that you have enabled "names" and
"values" (Tools---Options--- Chart and check the two boxes under
chart tips). When I move the mouse over a pie slice a floating box
will pop up that says:
Series 1 Point "xxxxx"
Value: xx (yy%)

I would like to be able to customize these chart tips.

Thanks.

Mike