title: Keep Chart Data Label from Wraping
body: <p>I have a project where I have to put user generated data labels in a chart. These need to be on a series line as such:</p>
  
  <p>![What I want format][1]</p>
  
  <p>However in some instances the text wraps.  How do I keep the text from wrapping in excel 10? see below</p>
  
  <p>![enter image description here][2]</p>
  
  <p>'-------- FORMAT DATA LABELS -------------------------------------</p>
  
  <pre><code>ActiveSheet.ChartObjects("OperBal2Takt").Activate
  h = 0
  For h = 2 To 7
      With ActiveChart.SeriesCollection(h).Points(1)
          .HasDataLabel = True
          .DataLabel.Text = Cells(2018 + h, 8).Value
          '.DataLabel.Width = msofit
      End With
  Next h
  </code></pre>