data labels to show value, label & percent

  • Thread starter Thread starter nihad
  • Start date Start date
N

nihad

Does anyone know how to show data labels for percent, label AND th
value all at once? I tried to use the concatenate formula, but i
won't keep formats, such as a dollar amount containing dollar sign
comma separators and correct decimal places. Thank
 
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
 
Back
Top