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

athaung

New Member
Joined
Jan 10, 2014
Messages
23
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!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,848
Office Version
365
Platform
Windows, MacOS
Negative Error Value must be cleared, and Positive Error Value must contain the range with the error bar values.
 

athaung

New Member
Joined
Jan 10, 2014
Messages
23
Oh goodness, that seems so obvious now. Thanks so much for the response - it worked perfectly!
 

Watch MrExcel Video

Forum statistics

Threads
1,095,534
Messages
5,445,047
Members
405,308
Latest member
kiteman112000

This Week's Hot Topics

Top