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

Ravi Kumar

Registered User.
Local time
Today, 16:14
Joined
Aug 22, 2019
Messages
162
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
Today, 06:44
Joined
May 21, 2018
Messages
8,463
Can you post the rowsource of the chart?
 

Ravi Kumar

Registered User.
Local time
Today, 16:14
Joined
Aug 22, 2019
Messages
162
Can you post the rowsource of the chart?
Hi ..I have attached my database.
 

Attachments

  • Daily Rework statistics.zip
    143.5 KB · Views: 223

MajP

You've got your good things, and you've got mine.
Local time
Today, 06:44
Joined
May 21, 2018
Messages
8,463
May need to repost. Verify your chart. My summary chart had no chart object. It was blank.
 

isladogs

MVP / VIP
Local time
Today, 10:44
Joined
Jan 14, 2017
Messages
18,186
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

  • Daily Rework statistics._v2.zip
    144 KB · Views: 243

MajP

You've got your good things, and you've got mine.
Local time
Today, 06:44
Joined
May 21, 2018
Messages
8,463
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

MVP / VIP
Local time
Today, 10:44
Joined
Jan 14, 2017
Messages
18,186
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, 16:14
Joined
Aug 22, 2019
Messages
162
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

Top Bottom