Given this limitation, it would seem impossible to extract a Bode plot, however, consider the well-known relationship between the closed loop and open loop responses of a feedback system.

The Bode plot is recognized for its simplicity and the simple asymptotic approach makes the method useful for both design and assessment of power system control loops.

I am getting rather pissed off at Excel. I keep trying to make a Bode plot with the X-axis being 5 Cycle semi-log (just a log10 axis would be alright too) and the Y-axis linear. I cannot find an ...