Return<\/strong>” key and you will see the results as shown below.<\/li>\n<\/ul>\n![\"sparkline-google-sheets\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/sparkline-in-Google-sheets.png\")
<\/p>\n
Customizing Line Sparkline in Google Sheets<\/h3>\n
1. “xmin” specifies the horizontal axis’s minimal value.<\/p>\n
2. The variable “xmax” specifies the highest value along the horizontal axis.<\/p>\n
3. “ymin” specifies the vertical axis’s minimum value.<\/p>\n
4. The variable “ymax” specifies the highest value along the vertical axis.<\/p>\n
5. “color” determines the line’s color.<\/p>\n
=<\/span>SPARKLINE<\/span>(<\/span>$B$2:$B$11<\/span>,<\/span>{<\/span>\"charttype\"<\/span>,<\/span>\"line\"<\/span>;<\/span>\"color\"<\/span>,<\/span>\"red\"<\/span>}<\/span><\/span>)<\/span>\r\n![\"sparkline-google-sheets\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/sparkline-in-Google-sheets1.png\")
\r\n<\/span><\/pre>\n6. “empty” specifies how empty cells should be handled. “zero” or “ignore” are examples of possible values.<\/p>\n
7. “nan” specifies how non-numeric data should be handled in cells. “Convert” and “ignore” are the two options.<\/p>\n
8. The value “rtl” defines whether the chart is shown right to left or not. True or false are the options.<\/p>\n
=<\/span>SPARKLINE<\/span>(<\/span>$B$2:$B$11<\/span>,<\/span>{<\/span>\"charttype\"<\/span>,<\/span>\"line\"<\/span>;<\/span>\"rtl\"<\/span>,<\/span>TRUE<\/span>}<\/span><\/span>)<\/span>\r\n![\"sparkline-google-sheets\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/sparkline-in-Google-sheets2.png\")
\r\n<\/span><\/pre>\n9. The chart’s “linewidth” controls how thick the line will be. A thicker line is indicated by a greater number.<\/p>\n
=<\/span>SPARKLINE<\/span>(<\/span>$B$2:$B$11<\/span>,<\/span>{<\/span>\"charttype\"<\/span>,<\/span>\"line\"<\/span>;<\/span>\"linewidth\"<\/span>,<\/span>2<\/span>}<\/span><\/span>)<\/span>\r\n![\"sparkline-google-sheets\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/sparkline-in-Google-sheets3.png\")
\r\n<\/span><\/pre>\nCreating Column Sparkline in Google Sheets<\/h3>\n
Let us consider the same dataset to create the column sparkline in Google Sheets. The steps to create a column\u00a0 sparkline are given below:<\/p>\n
\n- Step 1:<\/strong> Go to the cell where you would like to create the Column Sparkline.<\/li>\n
- Step 2:<\/strong> Now enter the following formula “=<\/span>SPARKLINE<\/span>(<\/span>$B$2:$B$11<\/span>,<\/span>{<\/span>“charttype”<\/span>,<\/span>“column”<\/span>}<\/span><\/strong>)<\/strong>“.<\/span><\/li>\n
- Step 3:<\/strong> Press the “Enter<\/strong>” button and you will see the results as shown below:<\/span><\/li>\n<\/ul>\n
![\"sparkline-google-sheets\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/sparkline-in-Google-sheets4.png\")
<\/p>\n
Customizing Column Sparkline in Google Sheets<\/h3>\n\n- The color of the chart columns is controlled by “color.”<\/li>\n<\/ul>\n
=<\/span>SPARKLINE<\/span>(<\/span>$B$2:$B$11<\/span>,<\/span>{<\/span>\"charttype\"<\/span>,<\/span>\"column\"<\/span>;<\/span>\"color\"<\/span>,<\/span>\"red\"<\/span>}<\/span>)\r\n![\"sparkline-google-sheets\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/sparkline-in-Google-sheets5.png\")
\r\n<\/span><\/span><\/pre>\n\n- “lowcolor” changes the color of the chart’s lowest value.<\/li>\n
- “highcolor” changes the color of the chart’s highest value.<\/li>\n<\/ul>\n
=<\/span>SPARKLINE<\/span>(<\/span>$B$2:$B$11<\/span>,<\/span>{<\/span>\"charttype\"<\/span>,<\/span>\"column\"<\/span>;<\/span>\"lowcolor\"<\/span>,<\/span>\"red\"<\/span>;<\/span>\"highcolor\"<\/span>,<\/span>\"green\"<\/span>}<\/span><\/span>)<\/span>\r\n\r\n![\"sparkline-google-sheets\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/sparkline-in-Google-sheets6.png\")
\r\n<\/span><\/pre>\n\n- The color of the first column is set by “firstcolor.”<\/li>\n
- The color of the last column is set by “lastcolor.”<\/li>\n<\/ul>\n
=<\/span>SPARKLINE<\/span>(<\/span>$B$2:$B$11<\/span>,<\/span>{<\/span>\"charttype\"<\/span>,<\/span>\"column\"<\/span>;<\/span>\"firstcolor\"<\/span>,<\/span>\"green\"<\/span>}<\/span><\/span>)<\/span>\r\n![\"sparkline-google-sheets\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/sparkline-in-Google-sheets7.png\")
\r\n<\/span><\/pre>\n\n- The color of all negative columns is set by “negcolor.”<\/li>\n<\/ul>\n
=<\/span>SPARKLINE<\/span>(<\/span>$C$2:$C$11<\/span>,<\/span>{<\/span>\"charttype\"<\/span>,<\/span>\"column\"<\/span>;<\/span>\"negcolor\"<\/span>,<\/span>\"red\"<\/span>}<\/span><\/span>)<\/span>\r\n![\"sparkline-google-sheets\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/sparkline-in-Google-sheets8.png\")
\r\n<\/span><\/pre>\n\n- “empty” specifies how empty cells should be handled. “zero” or “ignore” are examples of possible values.<\/li>\n
- “nan” specifies how non-numeric data should be handled in cells. “Convert” and “ignore” are the two options.<\/li>\n
- “axis” determines whether or not an axis must be drawn (true\/false).<\/li>\n
- The color of the axis is set by “axiscolor” (if applicable)<\/li>\n<\/ul>\n
=<\/span>SPARKLINE<\/span>(<\/span>$C$2:$C$11<\/span>,<\/span>{<\/span>\"charttype\"<\/span>,<\/span>\"column\"<\/span>;<\/span>\"negcolor\"<\/span>,<\/span>\"red\"<\/span>;<\/span>\"axis\"<\/span>,<\/span>TRUE<\/span>}<\/span>)\r\n![\"sparkline-google-sheets\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/sparkline-in-Google-sheets9.png\")
\r\n<\/span><\/span><\/pre>\n
![\"Sheets](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/09\/Sheets-Tips.png\")
<\/p>\n