Solved Chart Not Showing Currency Symbol $ (1 Viewer)

Weekleyba

Registered User.
Local time
Today, 16:09
Joined
Oct 10, 2013
Messages
586
I'm having trouble with a simple pie chart that I want to have in a report.
I'm not using modern charts.
The chart is fed by a table, FundingTypeCHART_T shown below.
1610637255335.png


The pie chart displays as numbers only. I want this in currency.
1610637317735.png


The row source for the chart, shows the currency, see below.
1610637397257.png


Opening the chart editor, I can change the format to currency for the Funding Amount column, but it converts back to a number once I save and open the report.
1610637525215.png
1610637599406.png



How can get this chart to show the currency symbol, $?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 14:09
Joined
Oct 29, 2018
Messages
21,358
Hi. Not in front of a computer now, but have you tried formatting the chart labels rather than the data source?
 

Weekleyba

Registered User.
Local time
Today, 16:09
Joined
Oct 10, 2013
Messages
586
Of course not.... Wow. I tried so many other things but did know I could pick the labels too and format.
Thanks DB!
 

theDBguy

I’m here to help
Staff member
Local time
Today, 14:09
Joined
Oct 29, 2018
Messages
21,358
Of course not.... Wow. I tried so many other things but did know I could pick the labels too and format.
Thanks DB!
Hi. You're welcome. Glad to hear you got it sorted out. Cheers!
 

Users who are viewing this thread

Top Bottom