[AccessD] Using Charts

Yes, get the min and max values of the dataset and then

With objGraph
  .Axes(2).MinimumScale = dblMin
  .Axes(2).MaximumScale = dblMax
End With

Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Mark A Matte
> Sent: 08 January 2004 14:55
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Using Charts
> 
> 
> Hello All,
> 
> I'm building a db in A97 (or in 2k if there is a difference 
> in charts)...the 
> values I am displaying are currency...and the ranges for each 
> data set are 
> different...is there away to have the charts MAX and MIN set 
> to the MAX and 
> MIN of the dataset...without having to edit the chart everytime?
> 
> Thanks,
> 
> Mark
> 
> _________________________________________________________________
> Check your PC for viruses with the FREE McAfee online computer scan.  
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>