Movie of Charts desired

[Ken Wills]

I'm having alot of trouble trying to show charts repeatedly.
I change the data that is the 'source' of the chart, but even with a
'refresh' it doesn't want to show anything, till the last one. What gives?
Any general hints or clues appreciated.

Thanks.
Ken

 

[Tushar Mehta]

Where is the chart(s)? How are you changing the source? What do you
refresh? How do you refresh? What doesn't show until what last one?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Ken Wills]

Tushar,

Thanks for replying!!
I'm making a little headroom with turning the debugging break on and looking
at the charts which show for every iteration fine.
So I placed a bunch of 'timing loops' but they don't work with a 'full run'
with no 'debug break on'.

Here is where the VB code starts within each 'interation' which refreshes
the underlying table (tblTEMPTableForOneArea)


Me.GraphDBRecs.Locked = False /* that is the chart name */
' I no longer use this and made a query instead...
' me.GraphDBRecs.RowSource = "SELECT (Format([ObsDate],"yyyy mm")) AS
Expr1, Sum(tblTEMPTableForOneArea.DBrecs) AS SumOfDBrecs FROM
tblTEMPTableForOneArea GROUP BY (Format([ObsDate],"yyyy mm")),
(Year([ObsDate])*12+Month([ObsDate])-1);"

Me.GraphDBRecs.RowSource = "qryRowSourceFor1AreaDBRecs"
'?? Me.Form.Recalc /* tried it now, tried it later.....*/
Me.GraphDBRecs.Requery

Hope this helps....

Thanks ,
Ken