Hello!

I'm learning rotation in 3d space.
but I do not understand, how excel calculate offset for Centre at rotation(left - right). What the general formula?

it's example camera offset
3dbarcharts.xlsx