Advanced Spreadsheets – Filter and Sort Data

Filter, sort data in a pivot table/data pilot. Filtering data means applying some conditions to the data so that only those data fields get displayed which satisfy these conditions. To filter data in a pivot table, simply right-click anywhere on the table and from the resulting menu, click on ‘Filter’. This will open the ‘Filter’…

Read More

Advanced Spreadsheets – Using Pivot Tables

Create and modify a pivot table/data pilot. A pivot table is a very effective and efficient tool for comparing, combining, and analyzing large amounts of data in a simple manner. To use pivot table, the first thing which is required is some raw data. The data should be in the form of a database table…

Read More

Advanced Spreadsheets – Format chart to display an image

Format columns, bars, plot area, chart area to display an image. In Calc charts, we cannot use custom images by importing them into the charts from our local machine. Though Calc does provide the option for using the different types of ‘Fill’ options for the columns, bars, plot area or chart area like ‘Color’, ‘Hatching’,…

Read More

Advanced Spreadsheets – Change scale of chart value

Change scale of value axis: minimum, maximum number to display, major interval. In Calc, the values displayed with the axes of a chart are normally the default ones which are selected by the system as per the data being used. In some cases, we might need to change these values, or require different intervals between…

Read More

Advanced Spreadsheets – Add a secondary axis to a chart.

To add a secondary axis to a chart, first of all select the chart. After this, right-click anywhere on the chart area, and from the resulting menu click on ‘Insert/Delete Axes’. This will open the ‘Axes’ dialog box. In this dialog box, we have two checkboxes under ‘Secondary Axes’. Check any one or both of…

Read More

Advanced Spreadsheets – Creating Charts

Create a combined column and line chart. A combined column and line chart is a combination of two chart types. It is useful for combining two distinct but related data series. To create a combined column and line chart in Calc, first of all we need to select some data which we are going to…

Read More

Advanced Spreadsheets – 3-D and Mixed Reference

Use a 3-D reference within a sum function. Till now we have seen how to use the cell ranges from the same sheet as the arguments for the functions. But we can also use cell ranges from other sheets as arguments for the function. This is known as 3-D referencing. To use 3-D referencing, use…

Read More