- #1

CAF123

Gold Member

- 2,919

- 88

I have a graph which I would like to add Y error bars to. When I click to add the error bars, it only allows me to add horizontal bars. This is very strange because the other graph I have, it allowed me to insert vertical bars.

Basically when I click on

It is if Excel is 'deciding' what error bars to give me.

Can anyone help?

EDIT: This is silly, now when I click on another graph I have created, I have vertical bars as my default... Vertical bars as default on two graphs, horizontal on the other - this makes no sense.

Many thanks.

Basically when I click on

**exactly**the same menu to insert error bars, on one graph it takes me directly to vertical error bars and on the other graph it only allows me horizontal bars. I have for the last twenty mins been trying to get vertical bars on the menu that gives me horizontal bars. I don't know what else to try. I googled my problem but it just says click on 'More error bars options', but this is what I do by default.It is if Excel is 'deciding' what error bars to give me.

Can anyone help?

EDIT: This is silly, now when I click on another graph I have created, I have vertical bars as my default... Vertical bars as default on two graphs, horizontal on the other - this makes no sense.

Many thanks.

Last edited: