title: Xlsxwriter display different types of data on chart
body: <p>I'm creating a program to gather data from google analytics and append the data to an excel sheet. I have everything displaying correctly except for the charts displaying Time and Percentage Values</p>
  
  <p>In the Xlsxwriter chart documentation it doesn't specify clearly what to do or if there is even anything to do.</p>
  
  <pre><code>chart = workbook.add_chart({'type':'line'})
  chart.set_chartarea({'border': {'none': True}})
  chart.set_legend({'position': 'none'})
  chart.add_series({'values':'$B$48:$B$59', 'categories': '=\$A$48:A$59'})
  
  worksheet.insert_chart('A18', chart)
  
  </code></pre>
  
  <p>This is the Data being Used to create the chart</p>
  
  <p><a href="https://i.stack.imgur.com/bGqPV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bGqPV.png" alt="data columns"></a></p>
  
  <p>The program does not realize what type of data to display and is resulting in this:</p>
  
  <p><a href="https://i.stack.imgur.com/7uBjS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7uBjS.png" alt="problem chart"></a></p>
  
  <p>My goal is to have the program understand I'm trying to graph time stamp data (4:38) and be able to display it on the chart in this example from a customized excel sheet</p>
  
  <p><a href="https://i.stack.imgur.com/zSRE3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zSRE3.png" alt="correct chart"></a></p>