need help updating chart (series in dynamic range)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have couple charts with series in dynamic range. In VBA, I tried to
update them using chart1.refresh. Somehow, not all the charts are updated.
Any idea?


Thanks
 
Jeff,

You might try adding a selection change event similar to one of the two
below to the sheet module that holds the charts . . .

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Calculate
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Row > 1 And ActiveCell.Row < 5 Then _
ActiveSheet.Calculate
End Sub

A recalculation is forced causing the charts to update.
 
Back
Top