I've got a Google Spreadsheet.
First sheet is a set of raw data for ratings of beers.
Then I have a pivot table on that data, showing beers grouped by brewery, with values for the countunique() of the beers from that brewery, the average() of the rating for beers from that brewery and the stddevp() for those ratings.
Then I have a bar chart showing the ratings by brewery.
I'd like to show error bars for each of the average rating columns - but when I edit the chart, under "advanced edit", "customization", "series", "AVERAGE of Rating", my only options for error bars are "none", "constant" and "percent". There's no option to base the error bars on another series from the pivot table, even if I include the series in the chart - that just gets me another series of bars.
How do I add error bars to my chart?