Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |