This isn’t the most elegant solution, but a little bit of trigonometry is needed for the calculations. Maybe someone can simplify it more. This worked for my four dimensional radar plot that I converted to eight dimensions to rotate it 45 degrees. If you have the original values in cells B2 and B4 and want to calculate what B3 is, use this formula:

=(B2*B4)/(SQRT(B2^2+B4^2)*(SIN((PI()/180)*(135-DEGREES(ASIN(B4/SQRT((B2^2) + (B4^2))))))))



EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng