how i can show less decimals?

[pracmt1515]

i need show less decimals on a column chart (picture below), its possible show 98.80 and not 98.8045977?

[RandyHayes · Accepted solution]

@pracmt1515 

Yes, but unfortunately, there is no way to do it within the Chart control.

You will need to add a column to your Items of the Chart control with the rounded value you want and then change the chart to display that column for its values.

Ex - Items Property :   AddColumns(yourOriginalItemsFormula, "RoundedValue", Round(yourValueColumn, 2))

Then change the series value to RoundedValue (or whatever you want to call your new value column)

I hope this is helpful for you.