data labels to show value, label & percent
 

Does anyone know how to show data labels for percent, label AND the
value all at once? I tried to use the concatenate formula, but it
won't keep formats, such as a dollar amount containing dollar sign,
comma separators and correct decimal places. Thanks


--
nihad
------------------------------------------------------------------------
nihad's Profile: http://www.excelforum.com/member.php...o&userid=30285
View this thread: http://www.excelforum.com/showthread...hreadid=501720

data labels to show value, label & percent
 

Hi,

You need to format the values within the CONCATENATE function by using
the TEXT function.
Assuming Value in A1 and % in B1 use something like,

=CONCATENATE(TEXT(A1,"$#0.00")," and ",TEXT(B1,"0.0%"))

Cheers
Andy

nihad wrote:
Does anyone know how to show data labels for percent, label AND the
value all at once? I tried to use the concatenate formula, but it
won't keep formats, such as a dollar amount containing dollar sign,
comma separators and correct decimal places. Thanks



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info