Technically you are limited to what you can do with error bars. You can work
around these limitations but its quite a chore. For example, create two
additional series one with a value of the lower error bar, the other with a
value of the amount the upper error bar extends beyond the lower. Add these
two series to the chart. One at a time change their axis to the Secondary
axis. Then change their type to Stacked column. Then change the color of
the lower series to none along with the border for that series. You may need
to also change the series order to get the error bars in front of the data.