Point Defect is known as imperfections, grouped by space.Point defects have zero dimension; line defects, also known as dislocations, are one dimensional; and planar defects such as surface defects and grain boundary defects have two dimensions. Point defects have equilibrium concentrations that are determined by temperature, pressure, and composition. Point Defect on semiconductors and insulators govern a variety of mechanical, transport, electronic, and optoelectronic properties. This article describes how to know Point Defect values of some metals in the form of graphs using the Spreadsheet application. Point Defect value against temperature is seen through graph. The value of some metals can be known. The data entered produces a different graph, ie Al metal has the largest Point Defect value among Au, Cu, and Pt metals.