title: How do I get charts.add command to deliver an empty chart?
body: <p>The command <code>charts.add</code> in VBA adds a new chart object to the workbook. I think hitting <code>F11</code> in Excel does exactly the same. </p>
  
  <p>The problem is, that this command uses the data around the at that point selected worksheet and cell to populate the chart. If there is no data or no usable data, it returns an empty chart.</p>
  
  <p>My question is: <strong>"How can I force the command to deliver an empty chart?"</strong>. I intend to populate the chart with VBA code thereafter. </p>
  
  <p>A simple answer to the question is to create a new empty worksheet and select cell A1 on that worksheet and then create a new chart, but that is a rather ugly solution. Any help on elegant solutions would be appreciated.</p>