Hi
I have some time series scatter plots which self-update (using names in the data series formula, which are defined using the OFFSET and COUNT functions). I need to add custom error bars to these data series but can not see how to do it so the error bars will auto-update as well. Excel does not seem to like me putting names in the forms used to specify the location of the error values so I'm baffled how to do this.