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.


    .SeriesCollection.NewSeries
    .FullSeriesCollection(1).Name = "=""Oil"""
    .FullSeriesCollection(1).Values = "='By Date'!$P$2:$P$5014"
    .FullSeriesCollection(1).XValues = "='BY DATE'!$F$2:$F$5014"
    .FullSeriesCollection(1).Format.Line.ForeColor.RGB = RGB(0, 176, 80)
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.