<div>
I have tried:<br />
<br />
&nbsp; &nbsp; ActiveChart.SeriesCollecti<wbr />on(1).XVal<wbr />ues = &quot;=results!R2C1:R5C1&quot;<br />
<br />
This does not work either....<br />
I get the error &quot;Invalid Parameter&quot;<br />

</div>


I have tried:

    ActiveChart.SeriesCollection(1).XValues = "=results!R2C1:R5C1"

This does not work either....
I get the error "Invalid Parameter"


<div>
Actualy <br />
<br />
ActiveChart.SeriesCollecti<wbr />on(1).XVal<wbr />ues = &quot;=results!R2C1:R5C1&quot;<br />
<br />
Works but it is still A2:A5,<br />
<br />
I want the first 5 visible rows...
</div>


Actualy

ActiveChart.SeriesCollection(1).XValues = "=results!R2C1:R5C1"

Works but it is still A2:A5,

I want the first 5 visible rows...

Book1.xls

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I have a chart that is list a bunch of suff (obviously). &nbsp;I have a visual basic script that filters this data down to four rows....<br />
<br />
I then have a graph that is based on the current four rows.<br />
<br />
My problem is that the rows may never be the same. &nbsp;So I can not write something like:<br />
&nbsp; &nbsp; ActiveChart.SeriesCollecti<wbr />on(2).Valu<wbr />es = &quot;='results'!$B$32:$B$35&quot;<br />
<br />
because the rows may be showing rows 131-134...<br />
<br />
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...
</div>
</div>


Hi All,

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...

Excel 2003 Make Graph on changing table

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.