View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default 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