According to the metrological requirement in verification regulation, we need to do mass calculation to grade the dial test indicator. So we are inclined to make mistake and work inefficiently. In this article, we use powerful Excel formula and chart function to make a template by writing a program. By this solution, we can achieve rapid processing error calculation and grade the dial test indicator. We just need to write the data in the right position of Excel and get all the results by using this program template. We need not manual error calculation and edit the formula again, raising working efficiency and accuracy.