Revolving $f(x)=\frac{1}{x}$ about $f(x)=x$ yields the two-sheeted hyperboloid $2xy-2=z^2$ in $\Bbb R^3.$
I'm trying to rotate the surface so that the forward sheet lies in the first octant $(+,+,+)$ and the backward sheet lies in $(-,-,-).$
What's the equation?
Here's what I have so far. This is the graph of $2xy-2=z^2:$
It would also work to rotate the two-sheeted hyperboloid $z^2-y^2-x^2=1.$
My attempt was to use a $3$d rotation matrix that rotates points about the origin. I was able to find the right rotation matrices, but I could not reason what to multiply the rotation matrix with to get the desired result. I could probably get the final equation, with a few hints.
I believe I have to change the entries in the matrix $Q$ (as shown in the hint below by @NinadMunshi). I'm not sure what to change them to, but the new entries should rotate the hyperboloid.

You want to rotate the surface so that the direction $(1,0,0)$ becomes $\dfrac1{\sqrt3}(1,1,1)$. A possible rotation matrix is
$$\begin{pmatrix}\frac1{\sqrt3}&0&-\frac2{\sqrt6} \\\frac1{\sqrt3}&\frac1{\sqrt2}&\frac1{\sqrt6} \\\frac1{\sqrt3}&-\frac1{\sqrt2}&\frac1{\sqrt6}\end{pmatrix}$$
Now your equation is
$$\frac{(u+v+w)^2}3-\frac{(v-w)^2}2-\frac{(-2u+v+w)^2}6=1$$
or
$$u^2+v^2+w^2-4uv-4vw-4wu+3=0.$$
Caution: sign and permutations errors are guaranteed, I didn't check. But the final result must not be far from correct.
https://www.wolframalpha.com/input/?i=plot+x%5E2%2By%5E2%2Bz%5E2-4xy-4yz-4zx%2B3%3D0