title: Google Apps Script - possible charts types
body: <p>I'm new to Google Apps Script so am just exploring if what I want to achieve is possible. </p>
  
  <p>From a Google form, I need to retrieve and display on a separate document the chart created from data on each individual form submission. I know this can be done.</p>
  
  <p>The problem I have is that the chart type I want does not seem to be available <a href="https://developers.google.com/apps-script/reference/charts/" rel="nofollow">here</a>.</p>
  
  <p>The chart needs to show a category and two values. This could be done with a bar chart, height is one value and colour the other value - this looks as though it might be possible but I am not sure if the colour of the whole bar can be changed.</p>
  
  <p>An alternative is the bubble chart, X axis for category, Y axis for one value and size for the other value - but this type of chart does not seem to be supported.</p>