/

How to Add Sparklines in LibreOffice Calc

558 views
1

LibreOffice introduces Sparklines in its spreadsheet program Calc. Here’s how to add it.

What is Sparklines?

Sparklines are small graphs which you can create inside a cell. It can be a line, stack or column graph based on a range of values.

From LibreOffice version 7.4 onwards, you can create Sparklines just like Microsoft Excel. You can also import Excel files to LibreOffice having sparklines or create XLSX files from LibreOffice.

In this article, I will discuss how easily you can create sparklines.

How to Create Sparklines – The easiest way

Let’s start with a simple set of data.

In this data, I have some random numbers per year and quarter.

Sample data for example
Sample data, for example
  • Now, to add Sparklines from the menu, select Insert > Insert Sparklines.
  • In the Sparkline properties window, select the Input Range for your data. Here in this example, B2 to E2.
  • The Output range is where the Sparklines will be created. You can choose any cell you want.
  • Next, select the Type of the lines. There are three self-explanatory types available: Line, Column and Stacked.
  • You can change the colours of various data types as well. Negative points are the values which are negative in the Input range. Similarly, high points, low points and marker colours can be selected.
  • If you want, you can also change the first data and last data colour values.

For this example, I have selected the followings.

Insert a basic Sparkline in Calc
Insert a basic Sparkline in Calc

Once done, press OK.

And you should see the Sparklines in the target cell, i.e. F2.

You can repeat the same for all other rows or columns. Or you can create sparklines in a group range which I have explained here.

A simple Sparklines created
A simple Sparklines created

How to Change Sparkline Range again and colour values

What if you want to change the range or some colours or types of Sparklines? Yes, that’s also possible.

  • To change the colours or types, select the Sparklines cell and choose Insert > Insert Sparklines from the menu.
  • To change the range, right-click on the Sparklines cell and choose Sparklines > Edit Sparklines.

How to add Sparklines for a group or range of cells

Its time consuming to add Sparklines to each cell. So, you can easily follow the above steps to create Sparklines for multiple cells.

All you need to do is select the Input Range for the entire data set and the Output range where you want it to be.

Here’s a quick video to show you the Sparklines groups.

Similarly, if you want to edit/delete the ranges of the group, you can select Right Click > Edit Sparklines Groups or Delete Sparklines.

Edit or Delete Sparklines
Edit or Delete Sparklines

How to Delete

You can find the delete option in the right-click context menu, as shown in the above image.

Video

Here’s a quick view to demonstrate the above steps for your easy understanding.

Don’t forget to subscribe to our channel.

Wrapping Up

I hope this guide helps you to create beautiful Sparklines in LibreOffice Calc. Do let me know in the comment box below if it helps.


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Join our Telegram channel and stay informed on the move.


arindam

Creator of libreofficehelp.com. The aim is to help as many people with easy-to-understand tutorials. Connect with me via Telegram, Twitter, LinkedIn, or send us an email.

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

1 Comment
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Ger

nice, it looks we’ve now an option to add a waterfall graphic 🙂

1
0
Would love your thoughts, please comment.x