ACCESS FEED: RE: [MS_AccessPros] generate a Simple graph from msaccess

Rabu, 23 Juli 2014

RE: [MS_AccessPros] generate a Simple graph from msaccess

a couple links that are well-written and have good examples of using VBA to make charts

Jon Peltier's Excel Charting Pages
http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html

Charting Tools for Excel by Ed Fererro
http://www.edferrero.com/charting.aspx

As long as you are using Access 2010 or lower, you can use the MS Graph Applet in Access. Code can change anything about the chart* -- and the RowSource changes what is graphed.

Explore the Microsoft Graph ##.0 Object Library
(Tools, References... from VBA window)

F2 = Object Browser

For information and examples:

1. go to a VBA window (Alt-F11)
2. Add the Microsoft Graph #.## Object Library (from the menu: Tools, References ...)
3. press F2 to go to the Object Browser
4. choose the Graph Library
5. click on Classes, Properties, Methods, etc, and press F1 for Help

To get the numeric value of a constant:

1. press CTRL-G to Goto the debuG (Immediate) window
2. type (for instance) -->
[b]? xl3DArea[/b]
and press [b]ENTER[/b]

the numeric value is -4098

~~~

the trick to getting what you want on a chart is the manipulate the RowSource.

~~~
change <All Libraries> in the Project/Library combobox in the upper left of the main window of the Object Browser window
to
Graph

explore each object in Classes
as you select a Class on the left, its members will appear in the pane on the right

when you see something you want help on, press the F1 key and switch to the Help window

You will see that Point is one of the classes you can choose -- and you can see all the properties for the point object listed on the right

1. choose "Point" from Classes
2. click on the "DataLabel" property on the right
3. press the F1 key

here is an example from help :

Code:
With myChart.SeriesCollection(3).Points(7)
.HasDataLabel = True
.ApplyDataLabels type:=xlValue
.DataLabel.Font.ColorIndex = 5
End With

The Object Browser gives you a way to explore what is available to you as you write code to act on MS Graph objects.

~~~

Microsoft Graph Object Model
http://msdn.microsoft.com/en-us/library/aa171177(office.11).aspx

Warm Regards,
Crystal

through sharing we will all get better
~ have an awesome day ~

--------------------------------------------
On Thu, 7/17/14, 'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Subject: RE: [MS_AccessPros] generate a Simple graph from msaccess
To: MS_Access_Professionals@yahoogroups.com
Date: Thursday, July 17, 2014, 4:50 PM

Onno Excel has some pretty good graphing
capabilities. See if it has something you can use. Then you
can link to an Access query to get the data. Regards,Bill

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, July 17, 2014 3:14 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] generate a Simple graph from
msaccess

Hi
Pro's, I have a database with
scientific data.Among these
are regression parameters, a, b, and c.From these a graphical
representation can be made by the formula y= ax +bx*x +
c.This represents a
second-order logistic curve or a parabole.I would like
to show a picture of this in my application, based on the
a,b,c values of each record How could i get this
done? By communicating with excel (but how? Anyone has
an example code?)I also found a
suggestion to use a Microsoft graph object ( and a
wizard).But I can not find how
to work with that. Any help and
other suggestions will be
welcomed! Thanks!  Onno M.
Knol

Onno.Knol@pbl.nl         http://www.pbl.nl