title: Print chartsheet without margin from excel using vba's .ExportAsFixedFormat method?
body: <p>I use the following routine to export (save) a chartsheet as pdf. The function gets the names of the user selected chartsheets in a collection. Then it exports one by one as a pdf where the user can select the save folder of the exported pdf. Here my code.</p>
  
  <pre><code>Private Function ExportCurvesPDF(Curves As Collection)
  Dim source As Workbook
  Dim i As Integer
  Dim FileName As String
  Dim ExportPath As String
  
  Set source = Thisworkbook
  
  ExportPath = "V:\"
  For i = 1 To Curves.count
      FileName = Application.GetSaveAsFilename(ExportPath &amp; Curves(i) &amp; ".pdf")
  
      If FileName &lt;&gt; "False" Then
         source.Sheets(Curves(i)).ExportAsFixedFormat Type:=xlTypePDF, FileName:=FileName, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
      End If
  
      ExportPath = common_DB.FolderFromPath(FileName)
  Next i
  
  End Function
  </code></pre>
  
  <p>The code works as expected and prints out the pdfs as an example below:</p>
  
  <p><a href="https://i.stack.imgur.com/E2uqV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/E2uqV.png" alt="This is how it looks in PDF"></a></p>
  
  <p>The pdf has quite the margin though and I want to reduce or remove it. I have tried to change the <code>IgnorePrintArea</code> property and the <code>IncludeDocProperties</code> property but nothing seems to have an effect on the margin. </p>
  
  <p><strong>Is there a way to reduce the margin with the <code>.ExportAsFixedFileFormat</code> ?</strong></p>
  
  <p>EDIT: I was asked to provide a screenshot of how the chart looks in excel: </p>
  
  <p><a href="https://i.stack.imgur.com/byURz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/byURz.png" alt="This is how it looks in excel"></a></p>