You can create a stacked sparkline using the StackedSparkline function in a formula: =STACKEDSPARKLINE(points, colorRange?, labelRange?, maximum?, targetRed?, targetGreen?, targetBlue?, tragetYellow?, color?, highlightPosition?, vertical?, textOrientation?, textSize?). The function has the following parameters: points: Reference that represents the range of cells containing all the values, such as "A1:A4". colorRange: (optional) Reference that represents the range of cells containing all the colors, such as "B1:B4"; default value is generated by color. labelRange: (optional) Reference that represents the range of cells containing all the labels, such as "C1:C4"; default value is empty string. maximum: (optional) Number that represents the maximum value of the sparkline; default value is the summary of all positive values. targetRed: (optional) Number that represents the location of the red line; default value is empty string. targetGreen: (optional) Number that represents the location of the green line; default value is empty string. targetBlue: (optional) Number that represents the location of the blue line; default value is empty string. targetYellow: (optional) Number that represents the location of the yellow line; default value is empty string. color: (optional) A string that represents the color for generating colors if colorRange is omitted; default value is "#646464". highlightPosition: (optional) Number that represents the index of the highlight area; default value is empty string. vertical: (optional) Boolean that represents whether to display the sparkline vertically. The default value is false. textOrientation: (optional) Number that represents the orientation of the label text. One of the following: 0: (default) Horizontal 1: Vertical textSize: (optional) Number that represents the size (in px) of the label text; default value is 10.