I'm trying to use the difference in values between two ranges as a range--the following code should convey what I'm trying to do, but VBA doesn't accept it. Is there a way to make this work without hosting the difference between the two columns in a third range, then using that for the series range? I'd rather not have it show on the worksheet.

ActiveChart.SeriesCollection(i + 2).Values = WS.Range(WS.Cells(26, 14), WS.Cells(wsrow, 14)) - WS.Range(WS.Cells(26, averagecolumn), WS.Cells(wsrow, averagecolumn))