Error Bar does not appear from Q3-Max when inserting range in "Custom Value"

[athaung]

Hi!

I've created a blot of box and whiskers for 3 separate x-axis categories. I've followed instructions posted by Peltier here: Excel Box and Whisker Diagrams (Box Plots) - Peltier Tech Blog. Everything works fine until I go to great the "upper" error bar

Chart Tools > Layout > Error Bars > Direction: Plus, End Style: Cap > Custom: Specify Value > Negative Error Value: *SELECT ALL AND DELETE default ={1} and select range for (Max - Q3) values* - This is driving me batty - please help!

 

[athaung]

Trying to post a screen shot image one more time!

 

[Jon Peltier]

Negative Error Value must be cleared, and Positive Error Value must contain the range with the error bar values.

 

[athaung]

Oh goodness, that seems so obvious now. Thanks so much for the response - it worked perfectly!