Excel dual category error bars

Occasional Visitor
Hi, I’m praying someone can help me -

Device - Mac
Excel version - 16.47.1

I am trying to add error bars to my graph but it is not picking up all the bars. When I try to custom error bars to add my standard deviation it doesn’t select all bars. It’s easier to see photos attached but each section has 4 clustered bars for each behaviour. The first section selects all bars, second doesn’t select the first, third doesn’t select the second, fourth doesn’t select the third and fifth doesn’t select the fourth... so there’s a pattern going on... not sure if I haven’t layed out my data correctly but I cannot find any information on this or how to add error bars to a graph like this, will be grateful for any advice.
0 Replies