# VBA error when setting error bars

**URL:** <https://forum.xltoolbox.net/t/vba-error-when-setting-error-bars/493>\
**Category:** bugs\
**Created:** [February 1, 2018, 9:39pm UTC](https://forum.xltoolbox.net/t/vba-error-when-setting-error-bars/493 "2018-02-01T21:39:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ummok](https://forum.xltoolbox.net/letter_avatar_proxy/v4/letter/u/c37758/32.png) [@ummok](https://forum.xltoolbox.net/u/ummok)\
**Post date:** [February 1, 2018, 9:39pm UTC](https://forum.xltoolbox.net/t/vba-error-when-setting-error-bars/493/1 "2018-02-01T21:39:34Z")

</div>

Hi, I’m trying to use the error bar tool. I have a graph with 32 series (I copy the graph and delete series that I don’t want to display later, but it’s easier to put all 32 series in one graph at once at first). My standard deviation numbers for my error bars are below my data in the same layout. I’ve tried both automatic mode and interactive mode and with both I get the following error after I click “Set Error Bars”:

VBA error #6 (Overflow) at clsErrorBars.SetLineErrorBars

I’m using Office 365 (excel 2016).

Thanks!

---

<div class="post-metadata">

**Author:** ![ummok](https://forum.xltoolbox.net/letter_avatar_proxy/v4/letter/u/c37758/32.png) [@ummok](https://forum.xltoolbox.net/u/ummok)\
**Post date:** [February 1, 2018, 9:49pm UTC](https://forum.xltoolbox.net/t/vba-error-when-setting-error-bars/493/2 "2018-02-01T21:49:36Z")

</div>

Actually I saw another post that said too many series will cause problems, so I lowered the amount of series per graph and it looks like it’s working. I’ll just stick to this method.

---

<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:** [February 2, 2018, 4:17am UTC](https://forum.xltoolbox.net/t/vba-error-when-setting-error-bars/493/3 "2018-02-02T04:17:02Z")

</div>

Hi,

is it possible for you to send me some sample data and chart that causes the error? You can either drop the file in the reply field of this forum (which will be public!), click on my user name to send me a private message, or just send it do [daniel@xltoolbox.net](mailto:daniel@xltoolbox.net).

Having said that, I believe (as I’ve probably said elsewhere) that a chart with 32 data series _and_ error bars might be somewhat hard to interpret. There may be better ways to present the data. That’s not meant to be an excuse for a bug in the XL Toolbox, but just a thought from the researcher in me.

Best  
Daniel

---

<div class="post-metadata">

**Author:** ![ummok](https://forum.xltoolbox.net/letter_avatar_proxy/v4/letter/u/c37758/32.png) [@ummok](https://forum.xltoolbox.net/u/ummok)\
**Post date:** [February 2, 2018, 9:00pm UTC](https://forum.xltoolbox.net/t/vba-error-when-setting-error-bars/493/4 "2018-02-02T21:00:44Z")

</div>

Thanks for the reply! Yes, I can send you some data that reproduces the error (although this time it says "VBA error #6 (Overflow) at " instead of “VBA error #6 (Overflow) at clsErrorBars.SetLineErrorBars”

> Having said that, I believe (as I’ve probably said elsewhere) that a chart with 32 data series and error bars might be somewhat hard to interpret.

Absolutely, putting everything into one graph at first then copying the graph several times and deleting series to show what I want to display was an easy method for me to make several graphs to show the data. But it’s not a big hassle to do the error bars _after_ I have separated the graphs. (Hope this makes sense).

---

<div class="post-metadata">

**Author:** ![system](https://forum.xltoolbox.net/uploads/default/original/1X/b39aeef1f68836c8cece0791714485f9a56b5d41.png) [@system](https://forum.xltoolbox.net/u/system)\
**Post date:** [September 2, 2024, 9:29am UTC](https://forum.xltoolbox.net/t/vba-error-when-setting-error-bars/493/5 "2024-09-02T09:29:16Z")

</div>

Closed on September 2, 2024, 9:29am UTC


