having a bit of trouble setting up a chart in my macro - the worksheet has been assigned to the variable mynewSheet and the data for the chart is in a range called mynewTable (inside mynewSheet). I need whats in column A (a list of team names)to go across the horizontal and column O(number of goals scored) to be the vertical.
tried something like the following which didnt work

Charts.Add
ActiveChart.ChartType = xl3DColumnStacked
ActiveChart.SetSourceData _
    Source:=mynewSheet(mynewTable.Range("A:0"))
ActiveChart.Location xlLocationAsObject, Name:="chartdata"