[AccessD] Using Charts

John Skolits askolits at ot.com
Thu Jan 8 10:04:09 CST 2004


This is not an exact answer to your question, but may help.

If you place a chart on a form and give the chart object thge following
name: "oleChart1"

You can change various items in the chart through code as follows:

(Values are for example only)
Me.oleChart1.Object.Application.Chart.Axes(1).MinorUnit = 5.5
Me.oleChart1.Object.Application.Chart.Axes(1).MajorUnit = 10
Me.oleChart1.Object.Application.Chart.Axes(1).BaseUnit = 2

Me.oleChart1.chartTitle.Text = "This is my chart's title"

Me.oleChart1.Object.Application.Chart.Axes(2).MaximumScaleIsAuto = True

Me.oleChart1.Object.Application.Chart.Axes(2).maximumscale = 1
---

'To get a count of different collections in the graph
me.oleChart1.seriesCollection.Count

---
Search for the Graph9 help file (GRAPH9.CHM) on your PC. I think this is for
Access 2000 but is pretty much the same for A97. It has examples of the
other properties and method.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte
Sent: Thursday, January 08, 2004 9:55 AM
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/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list