Google API Line Graph

I have a line graph here, and some reason the ideal line is not drawing.
The actual line is drawing a line, but the ideal is not

echo "<script>";
echo "google.load(\"visualization\", \"1\", {packages:[\"corechart\"]});";
echo "google.setOnLoadCallback(drawChart);";
echo "function drawChart() { ";
echo "var data = google.visualization.arrayToDataTable([
['id ','Ideal', 'Actual'],";

$number = 0;
$numbers = 1;


echo "[0,$sum,$sum2],";

Here is the code below that is breaking the line
(it draws the line if i have value where it says null)
(but it currently does not if the word null or no value in )

  • How do I get the location of a user?
  • remembering the user after login with google api (when the user “refresh” or moving to other page in my website)
  • Google Maps don't work sometimes… Or almost always not working
  • How can I convert image binary from API call to data URI in Javascript?
  • Getting Gmail Inbox using node.js and google-api
  • GAPI Is Not Defined
  • while($row = mysql_fetch_array($query))
    {
    $Ideal = $row['UserStoryPoints'];
    $Actual = $row['WorkRemain'];
                echo "[$numbers, null ,$Actual],";
    $numbers++;
    
    }
    

    echo "[$numbers,0,,],";
    
    echo "]);";
    
    echo "var options = {
        pointSize: 5,
    
      title: 'Burn down chart - $test',
         hAxis: {
             minValue: $numbers,
             format:'0',
             title: 'Each Day',      
        },
        vAxis: {
             format:'0',
             title: 'Number of hours',
        },
    };";
    
    echo "var chart = new google.visualization.LineChart(document.getElementById('chart_div'));";
    echo "chart.draw(data, options);";
      echo "}
    </script>";
    

  • Searching Google Spread Sheet API
  • Google API: Authorized JavaScript Origins
  • read/write Google Spreadsheet cell feed with Javascript
  • Google Autocomplete HTMLInputElement error
  • Automate the Import Function from Google Sheets
  • gapi.client.load not working
  • One Solution collect form web for “Google API Line Graph”

    Sorry is this too simple an answer?

    echo "[$numbers, $Ideal ,$Actual],";