<div>
<div class="content wysiwyg-content">
Hi Guys, 
 
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 
 
Range(&quot;A19:D28&quot;).Select 
ActiveSheet.Shapes.AddChart.select 
ActiveChart.setSourceData Source:=Range(&quot;'Quality'!$A$19:$D$28&quot;) 
ActiveChart.ApplyChartTemplate(&quot;Quality.crtx&quot;) 
ActiveChart.ChartTitle.Text = &quot;Quality&quot; 
 
Thanks heaps 
 
Gav
</div>
</div>

Hi Guys,

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

Range("A19:D28").Select
ActiveSheet.Shapes.AddChart.select
ActiveChart.setSourceData Source:=Range("'Quality'!$A$19:$D$28")
ActiveChart.ApplyChartTemplate("Quality.crtx")
ActiveChart.ChartTitle.Text = "Quality"

Thanks heaps

Gav

VBA - Moving and resizing chart

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.