Hi
I'm using google drive/spreadsheets and the built-in chart editor to generate a line chart.
The problem is that I can't find a way to set unique values for each error bar. Error bars are configurable under "Advanced Settings"->Customize. I can set them to be None, Constant or Percent. But what I want is to have them rendered using stdev data that I've calculated on my spreadsheet.
So, my questions are:
1. How can I customize error bars on a line chart in google docs using spreadsheet data?
or, if not possible:
2. Is it possible to use the charts API to customize the error bars in the script generated from Publishing in the Spreadsheet chart?
Thanks in advance
-nick