I am trying to automate a large number of charts.
The problem I am having is adding a second label to a pie chart. I
have added the name of the slice and its percentage but I'd like to add
an additional lable centered in the slice with its point change from
last year. I can do this by hand with text boxes but its a real pain.
Is there a way to add a label that changes based on what I put into a
cell?

Here is an example of what I am trying to do.

[image: http://www.bgphc.com/picture/chart-example.gif]


--
jpwolf00
------------------------------------------------------------------------
jpwolf00's Profile: http://www.excelforum.com/member.php...o&userid=23654
View this thread: http://www.excelforum.com/showthread...hreadid=377743