Forum Discussion

Mary2094's avatar
Mary2094
Regular Visitor
2 years ago

Help with box chart visual

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!

Need Help

2 Replies

    • Mary2094's avatar
      Mary2094
      Regular Visitor
      2 years ago

      Hi,

       

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

      PlantAverage ScoreAvg Score - deviationAvg Score + deviationLower LimitUpper Limit
      Belsk7.06.937.066.08.0
      Alba6.96.847.016.08.0
      Brantford6.86.686.996.08.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!