Visualizing data
Filter data in pivot table with slicers
What is a slicer? A slicer is more of a visual filter that helps you quickly filter data from one or more associated pivot tables. You can insert one or more slicers to filter your data. What is a slicer button? Slicer shows the data of the selected ...
How to align and resize objects in your worksheet?
Align multiple objects like charts, images and buttons based on other objects in your worksheet precisely using the visual indicators in Zoho Sheet. To align objects: Click and drag the object you wish to align with the other object until you see a ...
Working with pivot charts
Pivot charts, like the name suggests, lets you visualize the data while simultaneously letting you slice and dice the data just like a pivot table. Like any other chart, you can even customize how a pivot charts looks. Creating a pivot chart Click ...
Create sparklines, the in-cell graphs.
What are sparklines? Sparklines are in-cell graphs that represent a range of data. These sparklines help you quickly perceive the trend in the data. Sparklines can be further customized, on type of graph, color schemes and axes levels. Create ...
Create and customize charts to visualize data
Create a chart To create a chart: Select the range for which you need a chart. Click Insert > Chart. A chart is generated to best represent the data. Click the chart to open the contextual side panel. Edit or modify the chart type, design, title, ...
Create pivot tables to analyse your data
Create a pivot table in sheet To create a pivot table: Click Data > Pivot Table. Choose the range of cells from which the table is to be constructed and where the table must be created Drag and drop the fields into the desired positions in the Pivot ...