Connecting Tech Pros Worldwide Help | Site Map

Chart problem

 
LinkBack Thread Tools Search this Thread
  #1  
Old July 2nd, 2008, 05:25 PM
Phil Stanton
Guest
 
Posts: n/a
Default Chart problem

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
Call SysCmd(acSysCmdUpdateMeter, lCount)
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



 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,662 network members.