ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Need help creating a chart with standard deviation (https://www.excelbanter.com/charts-charting-excel/451057-need-help-creating-chart-standard-deviation.html)

ascrit

Need help creating a chart with standard deviation
 
1 Attachment(s)
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


All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com