<div>
See below code for 2 other options which can be underlined by any com code<br />
<br />
<br />

<pre><code id="code-618252">Sub AddNewChart()
Dim x As Variant
Set x = ThisWorkbook.Sheets.Add(Type:=xlChart)
x.Name = &quot;NewChart&quot;
Set x = ThisWorkbook.Charts.Add
x.Name = &quot;NewChart1&quot;

End Sub
</code></pre>
</div>


See below code for 2 other options which can be underlined by any com code




Sub AddNewChart()
Dim x As Variant
Set x = ThisWorkbook.Sheets.Add(Type:=xlChart)
x.Name = "NewChart"
Set x = ThisWorkbook.Charts.Add
x.Name = "NewChart1"

End Sub


<div>
The Charts.Add method worked perfectly!<br />
<br />
Thank you.
</div>


The Charts.Add method worked perfectly!

Thank you.

<div>
<div class="content wysiwyg-content">
I am trying to create a new worksheet of type xlChart (-4109) using the Excel COM interface.<br />
&nbsp;<br />
The .add method allows me to add 3/4 types of sheets.<br />
<br />
&nbsp; &nbsp; &nbsp;xlDialogSheet = -4116<br />
&nbsp; &nbsp; &nbsp;xlExcel4IntlMacroSheet = 4<br />
&nbsp; &nbsp; &nbsp;xlExcel4MacroSheet = 3<br />
&nbsp; &nbsp; &nbsp;xlWorksheet = -4167<br />
<br />
But the com interface throws an error when I try to create the &nbsp;xlChart (xlChart = -4109) type.<br />
<br />
Any suggestions on creating a xlChart type sheet in code?
</div>
</div>


I am trying to create a new worksheet of type xlChart (-4109) using the Excel COM interface.
 
The .add method allows me to add 3/4 types of sheets.

     xlDialogSheet = -4116
     xlExcel4IntlMacroSheet = 4
     xlExcel4MacroSheet = 3
     xlWorksheet = -4167

But the com interface throws an error when I try to create the  xlChart (xlChart = -4109) type.

Any suggestions on creating a xlChart type sheet in code?

excel worksheets.add xlchart

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.

Office Suites-Other

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