Excel 2003 Make Graph on changing table
Posted on 2010-08-29
I have a chart that is list a bunch of suff (obviously). I have a visual basic script that filters this data down to four rows....
I then have a graph that is based on the current four rows.
My problem is that the rows may never be the same. So I can not write something like:
ActiveChart.SeriesCollection(2).Values = "='results'!$B$32:$B$35"
because the rows may be showing rows 131-134...
So my question is, is there a way to put the values of a series based on an updated table.. wonder if this makes sense...