Stack Exchange network consists of 178 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I am using numbers 2014 - above is a screenshot that should explain it.
Double clicking on the error bars will let you change the values (as a formula). I found that after a lot of rage clicking.