Hello there! I have a smalle problem I thought was typical, but I can find no info on it on Google, in this forum or anywhere.
I have a series of charts, see underneath, that I am pretty happy about. However, from time to time I have to expand the charts data range with new columns. I'd like to be able to use VBA to update all the series to include the new columns.
As an example, I'd propose using this series: =SERIES('BIA Results'!$B$12;'BIA Results'!$D$1:$M$1;'BIA Results'!$D$12:$M$12;2)
The bold part where it needs changing with the VBA code.
Is that possible? Seems to me that it should "just" find the column using xlToRight, find the series the series and interchange it with and edited series with new values. I just cannot figure that out though.
I hope you can help,
GregersDK
(The picture upload refuses to work, so here are the links)
http://s21.postimg.org/3qb72qn93/Charts.png
http://s13.postimg.org/5y0uf5nrb/Matrix.png
Bookmarks