Problem in LC series resonance
Your Q is less than one (OK 1.75).

At Fres, the XL is 2 * PI * F * L, or about 7 * 24 or nearly 200 (the Mega and Micro cancel). The Q is XL / R = 200 / 100 = 2.

How about reducing the resistor, to 10?

Get a feeling for moderate Q peaking first.