Days should equal 34, and trying to reference it in the range - any ideas here please? it is failing on this line:
ActiveChart.FullSeriesCollection(1).Values = "=Revenue!O6:O & Days"
Sub Chart()
Dim RngToCover As Range
Dim ChtOb As ChartObject
Set RngToCover =...