I have the coding like this:
For Each chtObj In chtObjs
Select Case chtObj.Name
Case Is = "PriceTime"
With chtObj.Chart
.SeriesCollection(1).XValues = "='Q1'!R41C13:R" & MaxEnd & "C13"
.SeriesCollection(1).Values = "='Q1'!R41C14:R" & Bond1End & "C14"
.SeriesCollection(2).XValues = "='Q1'!R41C13:R" & MaxEnd & "C13"
.SeriesCollection(2).Values = "='Q1'!R41C15:R" & Bond2End & "C15"
End With
End Select
Next
When each time the field change, it will auto trigger this module and I expect the X-axis can refresh each time. However it can't. Is it because the array to set X-axis should be redim?
For Each chtObj In chtObjs
Select Case chtObj.Name
Case Is = "PriceTime"
With chtObj.Chart
.SeriesCollection(1).XValues = "='Q1'!R41C13:R" & MaxEnd & "C13"
.SeriesCollection(1).Values = "='Q1'!R41C14:R" & Bond1End & "C14"
.SeriesCollection(2).XValues = "='Q1'!R41C13:R" & MaxEnd & "C13"
.SeriesCollection(2).Values = "='Q1'!R41C15:R" & Bond2End & "C15"
End With
End Select
Next
When each time the field change, it will auto trigger this module and I expect the X-axis can refresh each time. However it can't. Is it because the array to set X-axis should be redim?