V
Viktor Ygdorff
I have been having great trouble with replwcing the series of existing
charts. I have the new data series for the charts but for some reason it is
quite difficult to get the charts to understand that they are supposed to
display these new values. The code is:
Do While k < (UBound(rng))
If Not IsEmpty(rng(k)) Then
ActiveChart.SeriesCollection(varWorksheetInfoArray(k)).Values =
Sheets(varWorksheetInfoArray(0)).Range(rng(k).Offset(i, 0).Address & ":" &
rng(k).Offset(j, 0).Address)
Else: End If
k = k + 1
Loop
I have really spent I alot of time trying to solve thÃs . The code is
correct in the sense that it gives the right data series it is just the
charts that are not keen on updating. Is it perhaps better to use replace or
substitute?
Does anyone know how to aplly these methods to my code?
charts. I have the new data series for the charts but for some reason it is
quite difficult to get the charts to understand that they are supposed to
display these new values. The code is:
Do While k < (UBound(rng))
If Not IsEmpty(rng(k)) Then
ActiveChart.SeriesCollection(varWorksheetInfoArray(k)).Values =
Sheets(varWorksheetInfoArray(0)).Range(rng(k).Offset(i, 0).Address & ":" &
rng(k).Offset(j, 0).Address)
Else: End If
k = k + 1
Loop
I have really spent I alot of time trying to solve thÃs . The code is
correct in the sense that it gives the right data series it is just the
charts that are not keen on updating. Is it perhaps better to use replace or
substitute?
Does anyone know how to aplly these methods to my code?