Link to home
Start Free TrialLog in
Avatar of Clif
ClifFlag for United States of America

asked on

Crystal Reports XI - Remove the Currency Symbol from Chart Legend

I have a pie chart that shows the counts of records within a group.

The number os correct, but the chart legend is showing a $ for each value.  I can't seem to figure out how to turn it off.

How do I get rid of the currency symbol on this chart?  (Note, there is a chart right next to it that does have dollar values and will need to retain the dollar sign)

TIA
Avatar of Mike McCracken
Mike McCracken

Are the values currency data type?
If so you could write a formula to convert the values to numbers

CDbl({YourCUrrencyField})

Have you tried right clicking on the numbers and clicking FORMAT?

mlmcc
Avatar of Clif

ASKER

No, the numbers are the result of a "Count" summary selected in the Chart Expert (Data tab/Show value(s)).

There is no "Format" option when selecting the number in the legend.  Well, there is, but not for number format.  The only options are "Font" and "Layout", neither of which allows for a selection that would remove the currency sign.
ASKER CERTIFIED SOLUTION
Avatar of Clif
Clif
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great.  Not sure I would have stumbled on that.

mlmcc
Avatar of Clif

ASKER

Solution provided by another source.
How do you put commas in the numbers?