error bars not transferring when switching row/column in excel

Hello. I created a clustered column bar chart with error bars (using the custom option). However, when I "switch row/column" only some of my error bars are included on the new chart. Is there an easy...