round off data label's value in chart in report (1 Viewer)

Ravi Kumar

Registered User.
Local time
Today, 05:22
Joined
Aug 22, 2019
Messages
142
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). Chart in access.JPG
 

MajP

You've got your good things, and you've got mine.
Local time
, 19:52
Joined
May 21, 2018
Messages
2,785
Can you post the rowsource of the chart?
 

MajP

You've got your good things, and you've got mine.
Local time
, 19:52
Joined
May 21, 2018
Messages
2,785
May need to repost. Verify your chart. My summary chart had no chart object. It was blank.
 

isladogs

CID Moderator
Staff member
Local time
Today, 00:52
Joined
Jan 14, 2017
Messages
12,550
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
 

Attachments

MajP

You've got your good things, and you've got mine.
Local time
, 19:52
Joined
May 21, 2018
Messages
2,785
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

CID Moderator
Staff member
Local time
Today, 00:52
Joined
Jan 14, 2017
Messages
12,550
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
Capture.PNG
 

Ravi Kumar

Registered User.
Local time
Today, 05:22
Joined
Aug 22, 2019
Messages
142
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
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom