I am making column charts in Excel. Does anyone know if it is possible
in Excel to setup the y error bar for each series so that it provides
multiple values? I would like dash marks, one for the std deviation and
one for std error mean, on the same vertical line. I've seen it done
elsewhere, and would be suprised if Excel doesn't have this feature,
but can't seem to find it.

Also, when I calculate the std error mean or the std deviation in
Excel, the returned value equals the size of the error in one direction
(ex. positive or negative) right? So if I use this value for a y error
bar, I should put it in twice, once in the positive box and once in the
negative box, which graphically doubles the total size of my error. Is
this correct, or is the value itself already accounting for error in
both directions, so that I should halve the value before putting it in
each box?


Thanks for your help,

Kerry