Hi Crystal

Thanks for coming back.

I assumed that the Microsoft Graph 2000 Chart was the same graph as used in
Excel. Am I wrong?

Have been to Jon's site frequently, and not coming up with any solutions.

At the moment I am getting away with it by getting Excel to produce the
information by getting the data from the database, creating the chart and
exporting it as a GIF file, then showing thid GIF file as an image on my
form. It works, but is messy. I hoped to dynamically update the graph on my
form as the data was changed.

Phil


"strive4peace" wrote in message
...
Hi Phil,

the king of charting with Excel is Jon Peltier and he has excellent help
on his website ... perhaps you can find something to help ...

Peltier Technical Services, by Jon Peltier
http://peltiertech.com/

~~~

Like you, I much prefer using Excel for charts than the MSGraph applet
that Access uses -- and I have found great stuff on Jon's site...


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Phil Stanton wrote:
I appreciate that this is an Excel forum, and I am using a chart object
in Access, but probably I will be better off posting it to this
newsgroup.

I am using a scatter chart on a form to show a map and points of interest
that I want labelled.

After a struggle I have loaded the map, loaded the point and from a
recordset, copied and pasted the label information into column 3 of the
chart's Datasheet.

Set DtaSheet = Cht.Application.DataSheet
For Each ChtLabel In ChtLabels
ChtLabel.Caption = DtaSheet.Cells(lCount + 2, 3)
lCount = lCount + 1
Next ChtLabel

This works OK but takes 20 seconds to label 68 points. I thought it might
be
quicker to do it this way rather than getting the label information
straight
from the recordset, but there is little difference in time.

What can I do to speed it up? Is there a way of loading all the labels at
once

Thanks

Phil