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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting of Data Labels in Histograms 4
Can't figure out Simple Percent Label 1
Inside Base Series Label Showing #N/A 0
Show Percent on Data Labels 2
Show data used and percent label 2
adding data labels to an XY scatterplot 1
Excel chart data labels showing % change instead of value? 1
Data labels other than charted values 1

Back
Top