data labels to show value, label & percent

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
 
A

Andy Pope

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
 

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

Can't figure out Simple Percent Label 1
Show Percent on Data Labels 2
adding data labels to an XY scatterplot 1
Show data used and percent label 2
Percent issues in 2007 2
How to put conditions in Excel Chart data labels? 4
Line Chart - show percent and value? 5
Data Labels- POssible to show data value and data label together? 1

Top