Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Retaining Formatting in 'joined' cells
In order to build a chart from my pivot tables that shows both a dollar
value, and a number of entries, I've downloaded XY Chart Labels so that I can use an unrelated cell as the label source. In that new cell, I have used the following command to generate my label: ="$"&ROUND(VALUE(D28),0) & "/" & VALUE(D27) where D28 is the $ value, and D27 is the number of entries. My problem is that the $ value doesn't include the comma in values exceeding 1000. The source cells show the formatting as I want it to appear on the chart. How can I get the chart label to look the same? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Retaining Formatting in 'joined' cells
Hi,
You need to format the result of the ROUND function. ="$"&TEXT(ROUND(VALUE(D28),0),"#,##0")& "/" & VALUE(D27) Cheers Andy On 15/02/2010 16:15, Dowitch wrote: ="$"&ROUND(VALUE(D28),0)& "/"& VALUE(D27) |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Retaining Formatting in 'joined' cells
Awesome. Worked brilliantly.
I knew it was probably something like that, but I'm really bad at using formatting in formulae. Thank you so much! "Andy Pope" wrote: Hi, You need to format the result of the ROUND function. ="$"&TEXT(ROUND(VALUE(D28),0),"#,##0")& "/" & VALUE(D27) Cheers Andy On 15/02/2010 16:15, Dowitch wrote: ="$"&ROUND(VALUE(D28),0)& "/"& VALUE(D27) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Charts not retaining formatting | Charts and Charting in Excel | |||
Remove Hyperlinks while retaining formatting | Excel Discussion (Misc queries) | |||
Retaining Manual Formatting in Pivot Tables | Excel Discussion (Misc queries) | |||
Can I lock 2 columns together so that the 2 cells in a row are joined? | New Users to Excel | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) |