# How To Use Sparkline in Google Sheets

The SPARKLINE function in Google Sheets is useful if you want to create a miniature chart contained within a single cell.

This function is very handy when presenting some data to your colleagues or superiors as it can quickly provide attractive visual representations. 💹

#### Let’s take an example:

As a student, you would like to track your exam results to keep track of your progress. You can simply use the SPARKLINE function to create a small line chart to give you an overall view of your results. You can see that the SPARKLINE function generates a simple line chart according to the data inserted into the formula in the image.

There are also many other options that you can insert into the formula to customize it. Instead of line charts, you can customize the chart type!

## The Anatomy of the SPARKLINE Function

The way we write the `SPARKLINE` function is:

`= SPARKLINE(data, [options])`

• The equal sign `=`  is how we start any function in Google Sheets.
• `SPARKLINE()` is our function. We need to add two attributes, namely the `data` and `[options]`, to make it work correctly.
• The `data` is the range containing the data to plot. In our previous example, it would be B3:B6.
• The `[options]` is a range of optional settings and associated values used to customize the chart. This attribute is optional. The formula will automatically plot a line chart if it is not inputted, as shown in our previous example.

Let’s explore the endless customizable options you can input into the formula!  Now that you have learned all the options available, let’s use some of these in an example!

## A Line Chart Using SPARKLINE Function

Very often, every year-end we are asked to have a meeting to discuss the performance of sales during the year. With the `SPARKLINE` function, you can easily create visualizations to let the listeners have a better understanding of the collected data.

Since the line chart is the default chart type, we would only need to specify the range of data. However, to make it more engaging and presentable, we can insert some options to enhance the outcome.

#### Example:

1. Simply click on the cell that you want to write down your function at. In this example, it will be D5:D7. Simply merge these cells to create a bigger cell to showcase the line chart. 1. Begin your function with an equal sign `=`, then followed by the name of the function, `SPARKLINE`, then an open parenthesis `(`. 1. We will then select cells B4:B15, as this is the range of data we would like to plot. Furthermore, we need to add a comma `,` to separate the `data` from our next attribute, the `[options]` 1. To start any options, we will need to insert a curly bracket `{`. Then, we can simply add in all the options we would like to customize the chart however we like. In this example, we want it to have a thicker line and be in the color blue. Hence, we would insert `linewidth` and `2` for a thicker line. For a blue line, simply insert `color` and `blue`. Do not miss out on the semicolon `;` to separate each option from one another!

1. Your input would look like this: Final formula:

`=SPARKLINE(B4:B15,{"linewidth",2;"color","blue"})`

## A Column Chart Using SPARKLINE Function

Let’s try creating a column chart using the SPARKLINE function. However, in this example, we would like to use different colors for the highest and lowest sales.

Example:

1. To create a column chart, we would need to insert `charttype` and `column` into the formula to specify the chart type. 1. Now, let’s customize the chart to show a distinction between the highest and lowest sales using different colors. We would make the lowest sales red by inputting `lowcolor` and `red`. Then the highest sales would be green. We will insert `highcolor` and `green` 1. Your input would look like this: ## A Bar Chart Using SPARKLINE Function

Unline the line and column charts. A bar chart does not take many values per chart.

Let us use some examples to demonstrate what this means.

#### Example:

1. Similar to the column chart, let’s specify which chart type we would like the formula to generate. We would insert `charttype` and `bar`. However, instead of selecting a range of data like before, we would only be selecting one cell. In this example, it would be B4. 1. Your input would look like this: The problem here is that the bar chart fills up the whole cell. There is no representation of data showing the performance of the entire year.  This is because when you create a bar chart, since each cell only knows the value of the bar it needs to create, there is no way to know how long the var can be.

To curb this, we would utilize the `MAX` option to create a comparative view.

1. Let’s insert `MAX` as another option. Then we would select the maximum amount in the range of sales we have, which is B15. We can also manually input the maximum value into the formula. 1. Your final input would look like this. ## A Winloss Chart Using SPARKLINE Function

Winloss charts are a special type of chart where there are only two outcomes, positive and negative. It does not show the magnitude of the data, unlike the column chart.

Let’s move on to an example to get a clearer understanding.

Example:

1. To get a winloss chart, we would need to insert the options `charttype` and `winloss`. 1. Let’s also customize the negative values using a different color. To do so, we will insert `negcolor` and `red`. 1. Your final input would look like this: As you can see, regardless of how high or low the sales is, all the columns are the same height.

You may make a copy of the spreadsheet using the link attached below and try it for yourself:

If this tutorial is interesting to you, do not miss out on our tutorials on various ways to create charts in Google Sheets! From creating Candlestick charts to Gantt charts, we have it all! Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'll love what we are working on! Readers receive ✨ early access ✨ to new content.

##### You May Also Like ## How to Use DAVERAGE Formula in Google Sheets

The DAVERAGE formula in Google Sheets is useful to get the average of values that meet specific criteria.… ## How to Track Stocks in Google Sheets ## How To Use IMDIV Function in Google Sheets

The IMDIV function in Google Sheets is useful when you need to divide a complex number with another… ## How to Use CUMPRINC Function in Google Sheets

The CUMPRINC function in Google Sheets is used to calculate the cumulative principal over a range of constant-amount…  