Excel Pie Chart and Chart tips
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
|