Pictures of charts don't allow us to see what you are doing in the spreadsheet, s it is difficult to see what you are doing wrong.
It looks like a basic rotation problem. It's too bad your math skills are not the greatest, because this looks to be a simple matrix multiplication. See wikipedia:
https://en.wikipedia.org/wiki/Rotati...Two_dimensions Remember that Excel has the MMULT() function for matrix multiplications:
https://support.office.com/en-us/art...3-e4ad3c7245eb
Also remember that, like almost all other programming languages, Excel's trig functions work with angles in radians.
Bookmarks