Found the issue.. I inserted the y values into the final lorentzian function and plotted this in the excel sheet instead of inserting the x values. Plots look good now.