Hey guys, so im just trying to automate some excel work while making some charts.

I have about 20 sets of data that I want to make charts of and I figured why not make a macro that will allow me to streamline the process.

Anyways, I want one macro that will select the data using "relative references" and then make a chart. So i select the first cell of the data, run this macro ->

ActiveCell.Range("A1:B5").Select
    ActiveSheet.Shapes.AddChart.Select
    ActiveChart.SetSourceData Source:=Range(-5, 0)
    ActiveChart.ChartType = xlColumnClustered
The macro does work and a chart is generated but i get an error code "Method 'range' of object '_global' failed. Which i cannot get rid of. The error is the (-5,0) which is the only part i modified and im 100% sure its wrong... but it still works .

Also, once that macro is working. I want to resize the chart and possibly (hopefully??) move the chart to an active cell 2 rows below the data that was used to select the chart.

Any idea's how to a) fix the first code and b) create the second?