# Error bars with Excel 2013 - Both top and bottom tail

**URL:** <https://forum.xltoolbox.net/t/error-bars-with-excel-2013-both-top-and-bottom-tail/40>\
**Category:** General discussion\
**Created:** [May 8, 2014, 9:23am UTC](https://forum.xltoolbox.net/t/error-bars-with-excel-2013-both-top-and-bottom-tail/40 "2014-05-08T09:23:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![thetoiletduck](https://forum.xltoolbox.net/letter_avatar_proxy/v4/letter/t/cc9497/32.png) [@thetoiletduck](https://forum.xltoolbox.net/u/thetoiletduck)\
**Post date:** [May 8, 2014, 9:23am UTC](https://forum.xltoolbox.net/t/error-bars-with-excel-2013-both-top-and-bottom-tail/40/1 "2014-05-08T09:23:48Z")

</div>

Hiya,

I was wondering if there’s a way to default error bars to top and bottom in Excel 2013?  
When using an older version of excel it would do both tails as default with the cell locations automatically pasted in, but with Excel 2013 i have to select each set of error bars \> Format Error Bars \> Both \> Custom \> Specify Value \> copy cell locations from Top to Bottom.

Many thanks  
Aidan

---

<div class="post-metadata">

**Author:** ![Daniel](https://forum.xltoolbox.net/user_avatar/forum.xltoolbox.net/daniel/32/6_2.png) [@Daniel](https://forum.xltoolbox.net/u/Daniel)\
**Post date:** [May 8, 2014, 1:27pm UTC](https://forum.xltoolbox.net/t/error-bars-with-excel-2013-both-top-and-bottom-tail/40/2 "2014-05-08T13:27:41Z")

</div>

Hi,

please have a look at the XL Toolbox Preferences, “Error bars” tab. You can make the error bars always point in both directions.

Kind regards

Daniel

---

<div class="post-metadata">

**Author:** ![jangoolee](https://forum.xltoolbox.net/letter_avatar_proxy/v4/letter/j/e79b87/32.png) [@jangoolee](https://forum.xltoolbox.net/u/jangoolee)\
**Post date:** [March 30, 2015, 3:43am UTC](https://forum.xltoolbox.net/t/error-bars-with-excel-2013-both-top-and-bottom-tail/40/3 "2015-03-30T03:43:53Z")

</div>

These “down” error bars (whiskers) extend from the bottom (left) edge of the 2Q Box … The new series is added as another column or bar stacked on top of the existing ones. … Excel draws both secondary axes, but the vertical one is hidden behind the primary … Wednesday, January 23, 2013 at 11:26 pm.