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

Kamis, 24 Juli 2014

RE: [MS_AccessPros] generate a Simple graph from msaccess

thanks, Bill :)

I LOVE charts!

oh, and you can also use MS Graph in Access 2013

I created a graph options menu for setting what to graph and what scale to use that needs the graphing stuff better isolated and secret data/logos removed ... thought I had already done that but I can't find it! If I stumble across it, I will post :)

Warm Regards,
Crystal

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

--------------------------------------------
On Wed, 7/23/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: Wednesday, July 23, 2014, 7:09 PM

Crystal As always, you provide invaluable
information. Thanks for taking the time to help out. I, for
one, am a graph dummy.

Regards,
Bill
Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852My Nothing-to-do-with Access
bloghttp://wrmosca.wordpress.com

________________________________________________
From: strive4peace

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