Format Number on a Chart

[wold1sim]

Hello,
I am trying to format a number value on the X Axis to no decimal point, but I don’t see any option that let you to do that. When I right click on the numbers, I get format axis label option, but it doesn't give you the option to format the number to no decimal point. The only option it gives you is to change the font type and angle. Help.
I appreciate it. I am using Crystal XI.
Thanks.

 

[bdreed35]

What chart type are you using?
I can right click one of the labels in the chart, get format axis label option, and then once in the Format Axis label dialog, there is a number tab that allows me to format to the desired format.

~Brian

 

[wold1sim]

I am using a Bar Chart.. I don't see any option to format a number.

 

[wold1sim]

I see the number tab as an option for the y-axis numbers. but I don't see the tab to format the x-axis.

 

[bdreed35]

What is the datatype of your x axis field?

~Brian

 

[wold1sim]

It is a date field. From the date field, I am getting the year using the year() function, then I changed to number using Tonumber function.

 

[bdreed35]

Instead of using the Year function, use totext to convert it instead:

totext({table.date},"yyyy")

This will control the output so that you don't get any decimals or commas

~Brian