[ascrit]

Hello experts, hoping for some quick help today.

I have a dataset that I am looking to chart. The data set is divided up into 6 groups. Most groups contain 2 values but one group has 5 values and 1 group has 1 value. I want to create a bar chart that shows two things:
1. The average of each group
2. The standard deviation of each group

I tried using a pivot chart to get the average of each group but I was unable to get the bars of standard deviation. Can anyone help??

I have attached a picture of my data