Help with box chart visual

[Mary2094]

Hi there, 

I need to build a visual as shown below. Here,  X axis is Plant name and Y axis is 'Average Score' measure (shown as black dash inside yellow box). I also need to display 2 more measures 'Average Score + 1std deviation' and 'Average Score - 1std deviation'. These 2 measures are shown as the yellow box around the 'Average Score' (shown as black dash).

I have created all 3 measures but I am unable to plot those in a chart like this. Any help on this is appreciated.

I have tried using box plot without success.

Thanks!

[vanessafvg]

can you provide some sample data in text form?

[Mary2094]

Hi,

Sorry for the delay in my response. Please see sample data below:

Plant	Average Score	Avg Score - deviation	Avg Score + deviation	Lower Limit	Upper Limit
Belsk	7.0	6.93	7.06	6.0	8.0
Alba	6.9	6.84	7.01	6.0	8.0
Brantford	6.8	6.68	6.99	6.0	8.0

Average Score should be shown as dash '-'. Avg Score - deviation is the lower part of the box shown in the image and Avg Score + deviation is the upper part of the box shown in the image in my original post. The 2 dotted green lines are Lower Limit and Upper Limit.

Thanks!