How to delete Horizontal (Category) Axis and Vertical (Value) Axis in chart?

Topics: Developer Forum
Jul 25, 2013 at 4:12 AM
I am trying to create an excel file containing a chart, and here's the code:
$categories = array(
  new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$B$1:$G$1', null, 4),
$values = array(
  new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$B$2:$G$2', null, 4),
$series = new PHPExcel_Chart_DataSeries(
  PHPExcel_Chart_DataSeries::TYPE_BARCHART,       // plotType
  PHPExcel_Chart_DataSeries::GROUPING_STANDARD,  // plotGrouping
  array(0, 1),                                    // plotOrder
  null,                                        // plotLabel
  null, //$categories,                                    // plotCategory
  $values                                         // plotValues
$plotarea = new PHPExcel_Chart_PlotArea(null, array($series));
$chart = new PHPExcel_Chart(
  'chart1',                                       // name
  null,                                           // title
  null,                                           // legend
  $plotarea,                                      // plotArea
  true,                                           // plotVisibleOnly
  0,                                              // displayBlanksAs
  null,                                           // xAxisLabel
  null                                            // yAxisLabel
Here's the result for the code:

Now I need to delete the Horizontal (Category) Axis and Vertical (Value) Axis. So here's what it needs to be:

Is there a way I can do this?