You can create an area sparkline using the AreaSparkline function in a formula: =AREASPARKLINE(points, min?, max?, line1?, line2?, colorPositive?, colorNegative?). The function has the following parameters: points: It is a range, such as "D1:D6". If a cell value is not a valid number, it will be treated as 0. min: (optional) A number that represents the minimum value of the sparkline. The default value is the minimum value in the range. max: (optional) A number that represents the maximum value of the sparkline. The default value is the maximum value in the range. line1: (optional) A number that represents a horizontal line's vertical position; the line does not exist by default. line2: (optional) A number that represents another horizontal line's vertical position; the line does not exist by default. colorPositive: (optional) A string that represents the color of the area in which the value is positive; default value is "#787878". colorNegative: (optional) A string that represents the color of the area in which the value is negative; default value is "#CB0000".