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