Setting number of decimals in MSGraph by vba?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arne Sørli - 09 May 2005 08:02 GMT

Hi,

I am using Access 2002 SP3 to graphical present data along with a Data Table
function. The object class which I am using is: MSGraph.Chart.8 The chart is
updated interactively from a Combo Box so data is constantly updated.

My problem is that the values shown in the Data Table have too many numbers
behind the decimal point. I can manually go into the graph and change each
column to 1 decimal, but the next time I update the graph, my changes are
gone.

Is there some way to permanently set the number of decimals and/or can it be
done through Access Basic?

Reply to this Message

Sophie Guo [MSFT] - 09 May 2005 11:09 GMT

Hello,

I am not entirely clear about the current situation. If you mean the chart
is based on one table, and the data in the table have too many numbers
behind the decimal point, I suggest that you perform the following steps:

1. Create a query. Use Round function to round the data to a specified
number of decimal places in the query.

For more information about the round function, please refer to the
following web page:

Round Function
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/ht
ml/vafctround.asp

2. Create the chart which is based on the query you created.

If I have misunderstood your concern, please post here the detailed steps
to reproduce the issue on the sample northwind.mdb database. I will check
the issue on my side.

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message