Due to the limitation of your worksheet data structure, you need to add the basic data of the chart in three times, and then modify the standard deviation data legend by changing the coordinate axis of the specified data series.

Steps:

1. Select the first average data area, press and hold the "Ctrl" key, and continue to add and select the second and third average data areas;

2. Insert the chart-histogram-series-added point values into the first set of standard deviations; And so on, plus the "standard deviation" of the second and third groups.

3. Point to Y axis-right-click menu-axis format-scale-change the maximum value to a number slightly larger than the maximum value in standard deviation.

4. Point to the first standard deviation data group-right-click menu-series data format-re-select the coordinate axis as "secondary coordinate axis", confirm, and so on to complete the coordinate axis setting corresponding to the second and third standard deviation groups;

5. With reference to the third step, check "Max" in the calibration of the main Y coordinate axis;

6. Refer to Step 5, change the maximum value in the right auxiliary Y-axis scale to an appropriate value, and confirm and exit the setting.