VBA error when setting error bars


#1

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!


#2

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.


#3

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.

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


#4

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).