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.

\1

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?

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.

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 <[email protected]>,
[email protected] 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
>
>