Hi, this is my first post!

I am stumped. Is this just a bug in Excel that I have to work around? I have an interactive bar chart with formatted 'custom' error bars which function fine if there is a non-zero value for each element in the series, but whenever the series is sorted with a zero value at the top I get a catastrophic error and Excel bombs out. It would appear that the format of the line is the issue (I have set it to a dashed line). If I reset the format to a solid line there doesn't appear to be an issue. Has anyone else come across this?

Thanks

Bev