First and last xlabels are not showing on the Line Chart .

[abnitchauhan]

I have created A morris Line chart By fetching data from the MySQL Table .
The problem I am getting is that Its not showing the first and last label of the x-axis.

Here is the Image :

[pierresh]

Hello,

Please give your code, including the dataset, so that we could reproduce your problem

[abnitchauhan]

Hi there
Here is my php code ,
<?php $query = "SELECT tots.*, @var := @var + tots.countFROM ( SELECT YEAR(created_at) ASyear, MONTHNAME(created_at) AS month, COUNT(*) AS count`
FROM users
GROUP BY month ORDER BY year DESC
) AS tots, (SELECT @var := 0) AS inc" ;

$result = mysqli_query($conn, $query) ;

 $json_data=array();  
  foreach($result as $rec)  
  { 
  // value on x axis 
  $json_array['label']=$rec['month']."/".$rec['year'];  
  // value on y axis 
  $json_array['value']=$rec['count'];  
  array_push($json_data,$json_array);
  } 
 //$chart_data = substr($chart_data, 0, -2) ;
 ?>`

And Here is my javascript Code :
'<script>
Morris.Line({
element: 'chart',
// json_encode returns JSON representation of a value
data: ,
xkey: ['label'],
ykeys: ['value'],
// Set to false to skip time/date parsing for X values, instead treating them as an equally-spaced
series.
parseTime:false,
labels: ['Number graph example'],
resize: true
});
</script> '

The data I am fetching is this

[pierresh]

It would be great you provide directly the dataset in javascript, I mean the content of JSON... So I just need to copy / paste... I do not need the PHP / MySQL..

[abnitchauhan]

Ofcourse . Here is the JSON

{"label":"February 2019","value":"4"}{"label":"January 2019","value":"6"}{"label":"March 2019","value":"5"}{"label":"December 2018","value":"2"}{"label":"November 2018","value":"3"}{"label":"October 2018","value":"2"}

[pierresh]

Seems the label are too long. You can try with shorter label, like Jan-19 instead of January 2019.

[xie3120]

The x-axis of my chart shows the phone number ,like 082111111750,last lable is not showing,i can not fix it