Sheet | Visualizing Data | Knowledge Base

Visualizing data
How to format your charts in Zoho Sheet
From the charts side pane, click the Format tab. From here, you can customize each of the chart elements. Select a chart element for which you wish to apply formatting. Switch to the desired sub-tab to customize the appearance of the selected ...
How to design your charts in Zoho Sheet
From the chart side pane, click the design tab, from where you can change the chart type, enable or disable chart elements. Chart elements supported in Zoho Sheet includes: Title: Allows you to enable/disable the chart's title. Subtitle: Allows you ...
How to create charts
Charts let you visualize your data and highlight patterns at a glance. Charts in Zoho Sheet come with a three-tab interface—Data, Design, and Format—that helps you create, design, format, and manage your charts. To create a chart Select the cell ...
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 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 ...

Access your files securely from anywhere

Start tracking your website metrics today

Use PageSense to understand what your visitors are looking for, how they are behaving, and where they are facing problems on your website.

Ready to improve your website's performance?

Install the PageSense code snippet on your site in a matter of minutes and start collecting in-depth data about the website visitors to grow your business.

Track and measure every business goal

Set up goals in PageSense to measure every single action performed by visitors on your website like button or link clicks, form submissions, and page engagements.

Understand the customer journey on your website

Create funnels in PageSense to quickly see which pages visitors use to enter your website, where they navigate to next, and which pages they decide to leave without converting.

Visualize your visitor's behavior with color codes

Set up heatmaps in PageSense to see where users have clicked more, how far they've scrolled, and on which parts of a page they've spent the most time using color-coded patterns in reports.

Measure customer engagement with your web forms

Use form analytics in PageSense to see how people interact with different fields in your form, whether they complete the form successfully or not, and where exactly they drop out on your form.

Record real visitor interactions on your website

Use session recordings in PageSense to watch a video of all the visitor actions performed on your website including the pages they navigate, the buttons they click, the UX issues they face, and more.

Test and optimize webpages for better conversions

Run A/B or Split URL tests in PageSense to figure out which version of your web page works best for your business and results in the best conversion rate.

Give each customer a unique website experience

Use personalization in PageSense to deliver customized versions of your website for every individual customer based on their demographics, local weather, browsing history, and more.

Grow your business through customer feedback

Run polls on your website using PageSense to understand what your customers think about your products/services and what needs improvement on your site.

Send timely updates that customers love

Use web push notifications in PageSense to schedule and notify your customers about an upcoming flash sale, product releases, promotional coupons, and a lot more that can spark conversions on your website.

Advertise your business to website visitors

Use pop-ups in PageSense to instantly grab the attention of visitors by showing attractive signup offers, coupon code discounts, or email newsletters that can eventually convert them into subscribers.

Access more advanced settings in PageSense

Use PageSense's advanced features like creating mutually exclusive groups, enabling cross-domain tracking, configuring customized project JS, and more to get deeper insights about your website.

Try easy-to-use extensions

Download the PageSense extension app available for your web browser with a few clicks and start collecting all of your required website metrics in real time.

Discover your favorite integrations with PageSense

Get a deeper look at your website's data by seamlessly integrating PageSense with a host of popular third-party apps like Google Analytics, Mixpanel, Intercom, and more.