$chart1->add_series
   (
    values => "=Sheet1!\$B$6:\$$column_count$6",  
    name   => 'Test data series 1',
  );