Chart in Excel

[NevilleT]

I posted this on the Access newsgroup but did not get an answer. I have a
form in Access with a chart which I am manipulating with VBA. This is the
message I posted on the Access Newsgroup.

I have a chart in a form. When I open the form it is blank until I click
around the form. It then displays. I have tried playing with the Auto
Activate property of the unbound object frame as well as including in the
form open event
Me.oleGraph.Verb = acOLEVerbOpen
Me.oleGraph.Verb = acOLEVerbHide
Me.oleGraph.Action = acOLEActivate
Me.oleGraph.Requery
in various combinations. the acOLEActivate displays the chart but in edit
mode. Has anyone come across this before.

 

[Shane Devenshire]

Hi,

I think the Access group what the correct place for this. You should let
them know what version of Access you are using. One reason you may not be
getting a lot of response is that Access is not the app of choice for
charting.

 

[NevilleT]

Hi Shane
Thanks for responding but the reason I posted here was I received no
response from the Access group. Seems there is much more knowledge about
charts in Excel groups than Access.

 

[Ed Ferrero]

Hi NevilleT,

You still need to ask in the Access groups because the charting engine used
by Access is different to the one in Excel.

Also, this sounds more like a form refresh problem than a charting problem.
Try adding commands like
DoEvents
Me.Recalc
Me.Refresh

Ed Ferrero
www.edferrero.com