Understanding the numerical data provided by a LibreOffice spreadsheet will always be very beneficial, it will speak well of you as a professional. LibreOffice Calc gives us the option to visually present the figures in a graph in your spreadsheet, you can make a dynamic bar or pie graph in Calc, they are an excellent support to better interpret the data that we have written down on the sheet You will be delighted to know that we have prepared this post so that you can learn how you can make one of these graphs.
It is important because the use of graphs plays an important role in understanding this data. With them it is easier to analyze, know, compare figures, situations and how they relate to each other. This allows our mind to better understand all those numbers presented.
Create your dynamic bar or pie chart using Calc in a few minutes
If you already have this program installed that comes with the free LibreOffice software, then open it and fill in the data you want to appear on the chart. It does not matter if there are many or few, the important thing is that they are well identified and organized so that the work becomes much easier for us.
As we all know, the spreadsheet has a set of cells that we can put in a range. Here will be present both the cells with the titles, as well as the figures assigned to them.
So what we will do is select the range of cells where all the information is. Once this is done, we go to the “Insert” section that we will locate at the top of the page.
A tab with several options will be displayed, we will notice that almost at the end is the one that interests us this time, the “Graphic” button. We click and now we will have the “Graphics Assistant” available.
We will see how automatically, a column chart that by default shows us the data is already reflected in the spreadsheet. But don’t worry, we have options to customize the information.
In the dialog that the “Graphics Wizard” window shows us on the left, we find four steps to make the modifications. These are: 1. Chart type; 2. Data range; 3. Data series and 4. Chart elements.
By pressing the first step, on the right we can select the type of graph we want. Here we will find the option “Bar” and “Circle” that we could also call cake.
Once the one we will use is selected, we can assign a shape and if we want the graph to be observed in 3D as well. As we are customizing the elements, we will see how it is also being modified in the spreadsheet.
If we already see that our bar or pie chart looks good, we press the “Finish” button and that’s it! It will be embedded in the sheet. We can also continue modifying it by pressing “Next”.
What other modifications can we make to our bar or pie chart?
Step 2, data range, shows us the cells where the information is and the variations that we can make in each row or column where there is data. We also assign which of the rows or columns we will place as a label.
Step 3, “Data Series”, is used when there are multiple data sets. While the fourth step, “Chart Elements”, is used to assign titles, subtitles, descriptions, display legends, and grids. Similarly, when making changes in all these fields, we press “Finish” and our graph will be ready.
This LibreOffice Calc tool to create our dynamic bar or pie charts will help us a lot in the presentation and interpretation of the information. You can also export graph files from XML to a Calc spreadsheet easily. In this tutorial we wanted to show you how to use it when creating your own graph. Your opinion is important to us, that’s why we want you to leave your comment in the box.
