Clif
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
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
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Great. Not sure I would have stumbled on that.
mlmcc
mlmcc
ASKER
Solution provided by another source.
How do you put commas in the numbers?
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