Charts - Number Formatting on X-Axis

[datenis]

Hi,

I have 2 problems. I'm using CR 10.

1. The X-Axis on the chart is based on a formula which returns a number. When the chart is displayed, 2 decimal places appear for each item on the X-Axis. I've tried to get rid of the decimal places by using Truncate(x), setting the number format on Report Options, and setting the number format under Chart Options -> Grid. However, none of these worked.

2. Removing trendlines. The trendline remains even after unchecking the "Show Trendlines" checkbox under the Series option.

Thanks in advance.