Excel Pie Chart and Chart tips

[mherman999]

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

 

[Jon Peltier]

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

- Jon

 

[Shane Devenshire]

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