Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need help updating chart (series in dynamic range)
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
Stock High-Low-Close Chart | Charts and Charting in Excel | |||
Dynamic series in Chart | Charts and Charting in Excel | |||
Dynamic charting problems (events) | Charts and Charting in Excel | |||
dynamic range for excel chart | Excel Discussion (Misc queries) |