title: Formatting the width of y-axis labels
body: <p>I am working on a VBA Excel script that uses a pivot table to create a bunch of charts and copy them into a Word document, creating a report.
  The charts come in pairs and, after pasting them, there's a slight "distance" between the y-axes.
  I wish to have them make a single line if they were extended.</p>
  
  <p>I'm using the <code>TickLables.Offset</code> property. It's set to the same value in both charts, yet that doesn't do the trick.</p>
  
  <p>Any suggestions are welcome.</p>
  
  <p>Edit:</p>
  
  <p>A screenshot of the issue: 
  <img src="https://i.stack.imgur.com/C3VMG.jpg" alt="Screenshot of issue"></p>
  
  <p>Code:</p>
  
  <pre><code>ActiveChart.Axes(xlValue).Select
  Selection.TickLabels.AutoScaleFont = True
  With Selection.TickLabels.Font
      .Name = "Arial"
      .FontStyle = "Normal"
      .Size = 10
      .Strikethrough = False
      .Superscript = False
      .Subscript = False
      .OutlineFont = False
      .Shadow = False
      .Underline = xlUnderlineStyleNone
      .ColorIndex = xlAutomatic
      .Background = xlAutomatic
  End With
  With Selection.TickLabels
      .Offset = 500
  End With
  </code></pre>