If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Line Chart - show percent and value? | PK | Charts and Charting | 5 | November 18th, 2005 04:24 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
from a FORM print a label report 3 labels per sheet for CURRENT re | babs | Setting Up & Running Reports | 7 | February 6th, 2005 06:38 PM |
data labels not linked to data source | viveleroi0 | Charts and Charting | 8 | August 19th, 2004 02:12 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |