NorthStar Analytics
Pricing

HiDocs High-Quality Ghost Documentation Theme

How to Use SPARKLINE Function in Google Sheets?

How to Use SPARKLINE Function in Google Sheets?

When working with Google Sheets, we sometimes show our table with the help of graphs for ease of reading. Graphs help us a lot for both ease of reading and analysis. Well, imagine that you made these graphs for the rows only, not for the whole table. This is great. We have individual charts for each product to analyze a sales list. Moreover, the graphics are fitted inside the cells. Also, you can find a detailed article about the graphics here→ “How to make a graph in Google Sheets?”

The types of charts we can make are as follows. Let's explain one by one in order.

We can make the following graphs with the SPARKLINE function.

  • Line Chart
  • Column Chart
  • Win-loss Chart
  • Bar chart

How to make a line chart with SPARKLINE?

Let's start with the order on our table. I have data of companies for three periods. We can show this data for companies one by one with line charts.

We create graphics for each row. For this;

  1. Come to the cell where you want the graph to be created.
  2. =SPARKLINE (cell range)
  3. When we create our graph for the 1st row, if we drag the small square on the lower right corner of the cell, graphs will appear in the other rows.

You can refer to this article to create a line chart containing the entire table→"How to make a line graph in Google Sheets?"

How to make a column chart with SPARKLINE function?

We create graphics for each row. For this:

  1. Come to the cell where you want the graph to be created.
  2. =SPARKLINE (cell range,{“charttype”,”column”})
  3. When we create our graph for the 1st row, if we drag the small square on the lower right corner of the cell, graphs will appear in the other rows.
  4. You can refer to this article to create a column chart containing the entire table→"How to make a bar graph in Google Sheets?"

How to make a win-loss chart with SPARKLINE function?

This chart type shows '0's as blanks and '1's as columns.

We create graphics for each row. For this:

  1. Come to the cell where you want the graph to be created.
  2. =SPARKLINE (cell range,{“charttype”,”winloss”})
  3. When we create our graph for the 1st row, if we drag the small square on the lower right corner of the cell, graphs will appear in the other rows.

How to make a bar chart with SPARKLINE function?

We may want to show the columns as bar charts according to their size. Here, it fills the bars according to the maximum value.

I entered the largest value in the data I have. For example, we might want to show the exam results according to the 100 system grades. Then we need to write 100 to the maximum value. If there are very large data, we can sort, copy and paste the largest value.

You can find a detailed article about the ranking here.→”How to sort in Google sheets?”

We create graphics for each row. For this:

  1. Come to the cell where you want the graph to be created.
  2. =SPARKLINE (cell range,{“chart type”,” bar”;” max”, X})
  3. When we create our graph for the 1st row, if we drag the small square on the lower right corner of the cell, graphs will appear in the other rows.

How to format charts?

How to format a line chart?

=SPARKLINE (cell range,{“color”,” green”;” linewidth”,4})

This both makes its color green and increases its thickness. Just write

=SPARKLINE (cell range,{“color”,” green” ”;” linewidth”, X) for the color.

How to format a column chart?

=SPARKLINE(B2:D2,{"charttype","column";”color”,”red”}) or ;

=SPARKLINE(B2:D2,{"charttype","column";”color”,”blue”;”lowcolor”,”red”;”highcolor”,”green”})

High values ​​are shown in green and low values ​​in red. Those in between are shown in blue.

Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.