Pages tagged with oocalc

• oocalc pie charts - Count occurrences of words in a column and create a pie chart from it The column should have a title in its first cell. Select the column. Data -> DataPilot -> Start. Use current selection. Window will pop up to define the data fields...
• oocalc notes - Notes about oocalc. Source cell range from different sheet Copy the range in sheet 1. Paste Special in sheet 2, selecting the Link option. Show rows hidden by a filter If you apply a filter and it hides a load of cells, select all cells (i.e....
• How to create a LibreOffice chart with two axes - In LibreOffice 3.5. Create your chart as normal. I’ll assume you’ve created some kind of line graph. Right-click on the chart and select Edit. Right-click and Insert/Delete Axis. Select a secondary Y axis. Now you’ll have tw...