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
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.
----
Regards,
John Mansfield
http://www.pdbook.com
"Jeff" wrote:
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks