Scatter Plot in Access with Labels

[Steff]

Hi,

I have an Access table with the fields "Productname", "Age" and
"Price". Now I want to generate a Chart with the "Age" as x-axis,
"Price" as y-Axis and the points in the chart should be labeled with
the "Productname". I can do the chart with the x- and y-axis but I
don't know how to label the dots in the chart. Any clue how to do this?

Thanks
Stefan

 

[strive4peace]

Hi Stefan,

getting coding help for Graph objects in Access

from the design view of any module, link to the Graph Library

from the menu --> Tools, References
check Microsoft Graph #.# Object Library
OK

Use the Object Browser to get help

from the menu --> View, Object Browser
OR
F2

On the left, you will probably see a Project window and a Properties
window below it
On the right, you will see the main Object Browser window

change <All Libraries> in the Project/Library combobox in the upper left
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 on using the DataLabel property, which is
ReadOnly:

'~~~~~~~~~~~~~~~~~~
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.



Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*