title: How to resize chart sheets in Excel
body: <p>To be clear, I'm not asking how to resize charts ON a worksheet, but how to resize Charts that ARE worksheets.</p>
  
  <p>I want to resize the chart to be 3.79cm high and 5.91 wide. </p>
  
  <p>Though I have done this in the past already, I'm currently at a loss of how I did it. I've been trying and playing around with the code below:</p>
  
  <pre><code>Sub qqq()
  Dim x
  
  With Chart6
      .ChartArea.Height = 379.03
      .ChartArea.Width = 591.03
  End With
  
  End Sub
  </code></pre>
  
  <p>When I try to run it I get "Run Time Error 5"</p>
  
  <p>What am I missing/not seeing?</p>