I have a data series that consists of multiple data series. I want to graph the average and the variance. I already calculated a single data series for the average and for the variance.
Now I want to display the data series with variance and I would like to use the error bars feature to display the variance. The problem is that you can only enter a single value for the whole data series. Is there a way to solve this with Google sheets or do I have to resort to Excel, where this is possible? I would like to do it with sheets, so I can collaborate on this with my colleagues.
This is my current graph, as you can see only one constant variance value is possible: