round off data label's value in chart in report

[Ravi Kumar]

Dear all ,

I have made a line chart in my report & the values are in percentage , I have rounded the decimal point in my query(source data for chart)
But still the chart is showing all the digits , please help me solve this .(to round off to only 1 decimal).

 

[MajP]

Can you post the rowsource of the chart?

 

[Ravi Kumar]

Can you post the rowsource of the chart?

Hi ..I have attached my database.

 

[MajP]

May need to repost. Verify your chart. My summary chart had no chart object. It was blank.

 

[isladogs]

MajP
its a modern chart which appear blank if using earlier versions of Access such as A2010.

Ravi
To alter the precision in the data points in modern charts you have to do that in the underlying query (or SQL)
Updated version attached

 

[MajP]

MajP its a modern chart which appear blank if using earlier versions of Access such as A2010.

Does that mean it is incompatible with older versions, or is there a way to see the chart? I do not event get an error, just a blank screen.

 

[isladogs]

Other than me doing a screenshot, there is no way of seeing the modern chart in older versions of Access.
Its one reason why I avoid using them in my own databases.
The traditional charts are still available and still work in A365.
Although (perhaps) slightly harder to work with, the traditional charts are more powerful/flexible.

Anyway here's the screenshot

 

[Ravi Kumar]

T

MajP
its a modern chart which appear blank if using earlier versions of Access such as A2010.

Ravi
To alter the precision in the data points in modern charts you have to do that in the underlying query (or SQL)
Updated version attached

Thank you so much