title: Date Range Google Chart Tools
body: <p>I'm trying to display data on a line graph using Google Charts. The data displays fine, however I would like to set a date range to be displayed.</p>
  
  <p>The data is sent from the database in a JSON literal format:</p>
  
  <pre><code>{
      "cols": [
                  {"label": "Week", "type": "date"},
                  {"label": "Speed", "type": "number"},               
                  {"type":"string","p":{"role":"tooltip"}},   
                  {"type":"string","p":{"role":"tooltip"}},   
                  {"type":"string","p":{"role":"tooltip"}},   
                  {"type":"string","p":{"role":"tooltip"}},   
  
              ],
      "rows": [
                 {"c":[{"v": "Date('.$date.')"},{"v": null},{"v": null},{"v": null},{"v": null},{"v": null}]},
                 {"c":[{"v": "Date('.$date.')"},{"v": null},{"v": null},{"v": null},{"v": null},{"v": null}]}
              ] 
  }
  </code></pre>
  
  <p>Data is either displayed by week or month (<code>null</code> for easy reading) for example this week:</p>
  
  <pre><code>2012, 02, 06
  2012, 02, 07
  2012, 02, 09 
  </code></pre>
  
  <p>Data isn't set for everyday of the week, therefore in this example only the dates above are shown. What I would like to be shown is the start of the week (2012, 02, 06) to the end of the week (2012, 02, 12) similar to the third example <a href="http://code.google.com/apis/chart/interactive/docs/customizing_axes.html#Terminology" rel="nofollow">here</a>.</p>
  
  <p>I managed to get the whole week showing by checking if the date exists in the database and if not append an extra row will null data, this however meant the line was not continuous and the dates where not in order.</p>
  
  <p>Could anyone offer any advice on how to I could go about doing this? </p>
  
  <p>Thanks!</p>