Have a chart showing 4 fields on x axis, Count, low $$, avg $$, high $$
Want count to be a whole number "32" and would like the $$'s to be 3 decimal points "$1.125"
In the chart layout I am using Data Type number and Format as entered. Not sure what "as entered" means.
If I look at the data in a table view, the $$'s are formatted x.xxx and count x
When viewed in chart $$'s show as 2 or 2.1 or 2.112
Is there a way to have mixed number formats on x axis ?