How to Select an entire table column for a Chart Series Values in VBA

[MattTran]

Hey all,

I'm writing a macro to make multiple graphs for me to save me tedious amounts of work.

I'm using AutoFilter so that only the rows I want to add to the chart series values are showing, but I'm having a hard time selecting the necessary range, which is the entire column.

Please Login or Register  to view this content.

Instead of using $P$2:$P$5014 & $F$2:$F$5014 (which adds ALL the rows, even the hidden ones), I want add the values only being shown after being autofilter. The ones that are being filtered out should not be part of the range.

I hope I was descriptive enough. Any help is appreciated.

[ajryan88]

Hi,

Try

Please Login or Register  to view this content.

And likewise for the line below.

Hope this helps

[MattTran]

Nvm solved my own problem. I just showed all for the data and it worked.

[MattTran]

Hi,

Try

Please Login or Register  to view this content.

And likewise for the line below.

Hope this helps

Thank you, this helped