Possible to add second data label to pie chart?

[jpwolf00]

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]

 

[Guest]

You could calculate the value in your worksheet and use Rob Bovey's XY Chart
labeler to plot that label.

http://www.appspro.com/Utilities/ChartLabeler.htm

 

[jpwolf00]

Maybe I am missing something in XY chart labeler. It allows me to use
different label but it erases my other labels. Is there a way to hav
both at the same time

 

[Guest]

I assume you have labels for different points in the series that may or may
not be SERIES NAME, CATEGORY NAME or VALUE. It's probably easier to just
have a "series" of data for the labels only if you use the XY Chart labeler

 

[jpwolf00]

I do have separate tiltles for each series however only one series
appears on a pie chart. I am guessing because excel can only graph one
series on the pie chart it ignores the extra one.

I need to have two separate labels, one for the name of the pie and its
percentage and another label in the middle of the pie with the change
from last year.

 

[jpwolf00]

I do have separate tiltles for each series however only one series
appears on a pie chart. I am guessing because excel can only graph one
series on the pie chart it ignores the extra one.

I need to have two separate labels, one for the name of the pie and its
percentage and another label in the middle of the pie with the change
from last year.

 

[Jon Peltier]

You get one data label per plotted point. I think you could use the
first trick in this page of Andy Pope's, and make the pie in front the
same size as the one in back, and use one pie for the outside labels and
the other for the inside labels.

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

 

[Tushar Mehta]

Create the composite label in a worksheet column by concatenating the
data in other cells and the nextline character, CHR(10). Now, use this
composite label column as the source for Rob Bovey's add-in.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions