I have the code below which will create a chart based on a template. This works fine however the chart when enbedded on the worksheet is too small and in the wrong position.
Is there a way using VBA code to resize the chart and also move it to the correct position on the sheet. Also, the title and vertical axis comes out empty. I can set the title as seen below but can't work out how to set the vertical axis title
ActiveChart.ChartTitle.Text = "Quality"