Barchart of pivot table with standard deviation

Hello everybody out there using Calc,

One of my most frequent tasks is to generate a bargraph of the average and standard deviation (as y error) for a given dataset.
That’s easy with Calc given a table with the average and the standard deviation, but I fail to generate the graph given a pivot table, because Calc will use the column with the standard deviation directly as the height of a new group of bars.

Any chance you could attach a example document so we can see what you mean?