Movie of Charts desired

  • Thread starter Thread starter Ken Wills
  • Start date Start date
K

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
 
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
 
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
 
Back
Top