Multiple Variables in Pie Chart Data Label Formatting

  • Thread starter Thread starter Bev
  • Start date Start date
B

Bev

I have recordsin a pie chart that contain the name of the variable, the
dollar cost and the percentage. No matter how the data is formatted, I an
unable to get the currency field, the dollar cost, to format as currency. I
validated the source data and in is formatted as currency but it shows up an
an number with no formatting.

How do I get the formatting in the currency portion of the label
 
In the source - whereever you are combining the items - you will need to
use the vba Format function.

Format(DollarCost,"Currency")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
No, I cannot. I have no idea exactly where you have combined the items.
Did you do it in the query, did you do it in the report?


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top