I am trying to automate a line chart to include new rows of data added in a column (from cell H11) using this VBA command:
ActiveChart.FullSeriesCollection(1).Values = _
ActiveSheet.Range("H11").End(xlDown).Select

However I keep getting an error >> Run-time error '91':Object variable or With block variable not set

Please help.