View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mike K
 
Posts: n/a
Default Dynamic data, static range, not updating.

Oh wise ones,
I have a range that is dynamically updated by a SQL
call. The data is changing every 2 seconds. The routine is populated by a
calulate sheet event. My range never changes, it is alway V4:V23 and the data
is updating and changing in that range, but the associated chart will not
update unless I call a refresh sheet function from a supplied addin or close
and reopen the workbook. Can anyone tell me why it won't refresh the chart
when the data linked to it is refreshing normally?

Mike