I have two predictors $X_1$ and $X_2$, they are positively correlated. The response $Y$ are positively corrected with both $X_1$ and $X_2$, i.e. if we fit regression $Y=\beta_1 X_1$ and $Y=\beta_2 X_2$, the estimates are both positive. Now I fit $Y=\beta_1 X_1+\beta_2 X_2$, I understand that it is well possible that one of the estimated $\beta_1$ and $\beta_2$ flips sign. I understand the discussions in this post and this post but I really want to see this effect geometrically. That is, assume all the vectors are in $\mathbb{R}^3$, I want to draw three vectors such that Cor$(Y,X_1)$ and Cor$(Y,X_2)$ are positive when I project $Y$ onto $X_1$ and $X_2$ separately, but I want to see the sign of one of the correlations flips when I project $Y$ onto the column space of $[X_1\>X_2]$ first.
Could anyone please draw me an example? I struggle to see this visually.