Possible to add second data label to pie chart?
 

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

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" wrote:


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

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


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

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" wrote:


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


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

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
------------------------------------------------------------------------
jpwolf00's Profile: http://www.excelforum.com/member.php...o&userid=23654
View this thread: http://www.excelforum.com/showthread...hreadid=377743

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
------------------------------------------------------------------------
jpwolf00's Profile: http://www.excelforum.com/member.php...o&userid=23654
View this thread: http://www.excelforum.com/showthread...hreadid=377743

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/
_______


jpwolf00 wrote:

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.

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

In article ,
says...

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
------------------------------------------------------------------------
jpwolf00's Profile: http://www.excelforum.com/member.php...o&userid=23654
View this thread: http://www.excelforum.com/showthread...hreadid=377743