I struggled with this for a while too. I found that if I move the
chart to an object in the sheet where my data is, I can select the
data ranges without changing sheets, which seems to work fine without
crashing. I just add my error bars and then move my chart back to
where it was when I'm done. It's klugey but it seems to work for
now.