survival8: Creating and Editing Line Chart in LibreOffice Calc

Sunday, June 12, 2022

Creating and Editing Line Chart in LibreOffice Calc

1 - 'About LibreOffice' for checking version



2 - Opening a .xlsx file created in MS Excel 365 in LibreOffice Calc



3 - Insert Chart button in LibreOffice Calc



4 - When you click on it, you get a bar chart and a 'Chart Wizard' window opened on your screen



5 - There you have to set 'Chart Type' to Line and on the right side select 'Lines Only' design



6 - When you click on 'Next' you get to see the Data Range



7 - When you click on 'Next' you get to see the Data Series



8 - When you click on Next, you get to the 'Chart Elements'



9 - Then click 'Finish' to get a Line Chart like what MS Excel clreates



10 - Next we add a dummy row to our table data



BUT:
But we cannot do it like Microsoft Excel in Calc by simply click on the chart and drag on the data boundary to extend the data range input to the chart.

In LibreOffice Calc:
11. We have to right click on the chart and get to the Edit Button.



12. Once we click on the 'Edit' button, Data Ranges get selected. Now we right-click on the 'Chart Area' again to get to the 'Data Ranges' Context Menu Option.


13. Our existing 'Data Range' looks like this:


14. We change it to:
$Brazil.$A$1:$B$41



15. When we click on 'OK', our chart reflects the change.