Lately I was struggling with displaying bars displaying average response along with standard deviation on them. Finally I found a way to show it!
You can change color or do formatting changes as you wish!
Lets first create a standard bar chart as shown above with Average response. Now add Standard error calculation
Now create two calculated fields : Average plus standard error and Average minus standard error as below:
Now add these two calculated fields in Marks section and create a calculated field for count of responses and add it in the marks section as well.
Now Click on SHOW ME option on the right and select Bullet Graphs
Then change the chart drop down in marks section to Bar again
Now right click on the grey area in the chart and click on edit
Change the style to Band and in Band from add : Avg - Std Error and Band to : Avg + Std Error
Then select Label on count field in Marks section.
Once you complete these steps you should see something as below:
You can change color or do formatting changes as you wish!