The invention belongs to the field of geotechnical engineering, and discloses a method for solving parameters in Duncan-Chang hyperbolic model based on Excel. The method comprises the following steps: importing triaxial compression test original data into an Excel worksheet; processing Triaxial compression test original data by using an Excel function calculation function to obtain triaxial compression test most basic data, initial data, Auxiliary parameters of a Duncan-Chang hyperbolic model and Model parameters of the Duncan-Chang hyperbolic model; Solving a triaxial compression test shear strength index by utilizing an Excel software planning and solving function; And finally, drawing a plurality of moire stress circles and strength envelope lines by utilizing an Excel software automatic drawing function. According to the invention, the operation is carried out on the visual interface, the operation is simple, the calculation result is accurate, the drawing is automatic, and thegraph is beautiful. And meanwhile, the worksheet can be stored for repeated use, so that the working efficiency is improved. The method disclosed by the invention can be universally applied to experiment teaching and scientific research.