Multiple Data Labels on a Pie Chart

[business_analyst]

Hello All,

So I have a table with 8 rows and 3 columns. This table includes:
Column 1 - shipment name
Column 2 - shipment cost
Column 3 - shipment weight

I have created a pie chart from this table, which covers the first two columns. Displayed next to each slice is a label with the shipment name, shipment cost, and percent share of the pie.

The issue is that I would like to include the shipment weight (column 3), in each label as well, but ONLY for display purposes, I do not want to change what is being graphed in any way. I did some sleuthing, but there seems to be no ready made way to do this. I even thought about concatenating column 1 and column 3, in order to graph costs but show name and weight. However, number formats do not stick with concatenations so that idea didn't work so well.

Any suggestions would be greatly appreciated. Thanks.

 

[VoG]

This might help http://www.appspro.com/Utilities/ChartLabeler.htm

Or you can maintain number formats in concatenations like this

="The value is "&TEXT(A1,"0.00")