multiple data label formats

  • Thread starter Thread starter ob3ron02
  • Start date Start date
O

ob3ron02

Is it possible from a single data range to create a chart (pie) wit
data labels of both "show percent" and "show value" next to each other
The wizard only lets you pick one and I've got a large number of thes
to do so i'd rather not put it in manually. Any help is appreciated
Thanks,

To
 
Hi,

You will need to use a helper column to bbuild the required label with
formula and the use this free addin to link data labels to cells.

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

Here is a very simple example. Chart data is in A1:B3
in cell C1 type this formula, which will display the value and the
percentage

C1: =B1 & "," & TEXT(B1/SUM($B$1:$B$3),"0.0%")

The option of value and percent is built into the latest version of xl

Cheers
Andy
 
Actually, you could use this column as your categories, and apply category labels to
the pie wedges. Of course, the legend will reflect these labels.

In Excel XP (2002) and later, you have the ability to display multiple items in the
data labels.

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