title: PHPExcel - Y-Axis overlaps data chartarea
body: <p>I am having a problem with the y-axis label positioning in PHPExcel.  </p>
  
  <p>When I create a chart, the y-axis labels are not appearing to the left of the plot area, they are always overlapping the plot area, starting at category 4 instead of 0.  </p>
  
  <p>I am assuming the issue is being caused by my category-x-axis values and Excel not being able to determine where to place the y-axis relative to the data.  My category (x-axis) values are in string form:</p>
  
  <pre><code>yyyy, i.e. 1980 1981 1982 1983 etc.
  </code></pre>
  
  <p>And here is my PHPExcel chart creation code, all working except for the y-axis positioning.</p>
  
  <pre><code>$labels = array(
      new PHPExcel_Chart_DataSeriesValues('String', "'Report Summary'!C1", null, 1),
      new PHPExcel_Chart_DataSeriesValues('String', "'Report Summary'!D1", null, 1)
  );
  $chrtCols = "'Report Summary'!B2:B$rowNum";
  $chrtVals = "'Report Summary'!C2:C$rowNum";
  $chrtVals2 = "'Report Summary'!D2:D$rowNum";
  $periods = new PHPExcel_Chart_DataSeriesValues('Number', $chrtCols, null, $rowNum-1);
  $values = new PHPExcel_Chart_DataSeriesValues('Number', $chrtVals, null, $rowNum-1);
  $values2 = new PHPExcel_Chart_DataSeriesValues('Number', $chrtVals2, null, $rowNum-1);
  $series = new PHPExcel_Chart_DataSeries(
      PHPExcel_Chart_DataSeries::TYPE_AREACHART,       // plotType
      PHPExcel_Chart_DataSeries::GROUPING_STANDARD,  // plotGrouping
      array(0,1),                                       // plotOrder
      $labels,                                        // plotLabel
      array($periods,$periods),                                // plotCategory
      array($values,$values2)                                  // plotValues
  );
  $series-&gt;setPlotDirection(PHPExcel_Chart_DataSeries::DIRECTION_COL);
  $layout = new PHPExcel_Chart_Layout();
  
  $plotarea = new PHPExcel_Chart_PlotArea($layout, array($series));
  $chart = new PHPExcel_Chart('sample', null, null, $plotarea);
  $chart-&gt;setTopLeftPosition('A1', 24, 24);
  $chart-&gt;setBottomRightPosition('B18', -24);
  $actSheet-&gt;addChart($chart);
  </code></pre>
  
  <p>Is there a setting to tell the y-axis to cross the x-axis at category 0 rather than it automatically selecting the wrong intersection?  Or is there a way I can alter the source data to make it automatically select the correct intersection?</p>
  
  <p><img src="https://i.stack.imgur.com/ujdVe.png" alt="enter image description here">
  EDIT: A 'possible' workaround may be to simply set the y-axis Line Color to "no Line", and the y-axis label display to "low" rather than "nextTo", however, I do not think PHPExcel has the ability to alter axis Line Color settings at this point.  Or does it?</p>