Skip to product menu
close
  • Recent Launches
    Press Space or Enter to display list of options
EXPLORE ALL PRODUCTS

Recent Launches

New

Payroll software with automated tax payments and filing.

Try now
New

Robotic process automation software to automate high-volume, rule-based tasks.

Try for free
New

Low-code IoT platform and solutions for connected businesses.

Try now
New

Business formation service to launch and grow your businesses.

Try now
New

Privacy-friendly application analytics solution.

Try for free

Sales

 
CRM

Comprehensive CRM platform for customer-facing teams.

CRM
 
Bigin

Simple CRM for small businesses moving from spreadsheets.

Bigin
 
Forms

Build online forms for every business need.

Forms
 
SalesIQ

Live chat app to engage and convert website visitors.

SalesIQ
 
Bookings

Appointment scheduling app for consultations with customers.

Bookings
 
Sign

Digital signature app for businesses.

Sign
 
RouteIQ

Comprehensive sales map visualization and optimal route planning solution.

RouteIQ
 
Thrive

Complete loyalty and affiliate management platform.

Thrive
 
Voice

Cloud Contact Center Software for businesses.

Voice
 
Suites
CRM Plus

Unified platform to deliver top-notch customer experience.

CRM Plus

Marketing

 
Social

All-in-one social media management software.

Social
 
Campaigns

Create, send, and track targeted email campaigns that drive sales.

Campaigns
 
Forms

Build online forms for every business need.

Forms
 
Survey

Design surveys to reach and interact with your audience.

Survey
 
Sites

Online website builder with extensive customisation options.

Sites
 
PageSense

Website conversion optimization and personalisation platform.

PageSense
 
Backstage

End-to-end event management software.

Backstage
 
Webinar

Webinar platform for webcasting online webinars.

Webinar
 
Marketing Automation

All-in-one marketing automation software.

Marketing Automation
 
LandingPage

Smart landing page builder to increase conversion rates

LandingPage
 
Publish

Manage all your local business listings on a single platform.

Publish
 
SalesIQ

Live chat app to engage and convert website visitors.

SalesIQ
 
Sign

Digital signature app for businesses.

Sign
 
Thrive

Complete loyalty and affiliate management platform.

Thrive
 
Voice

Cloud Contact Center Software for businesses.

Voice
 
NEW
LeadChain

Sync, manage, and convert leads across channels seamlessly.

LeadChain
 
NEW
CommunitySpaces

Online community platform for individuals and businesses to grow their network and brand.

CommunitySpaces
 
Suites
Marketing Plus

Unified marketing platform for marketing teams.

Marketing Plus

Commerce and POS

 
Commerce

eCommerce platform to manage and market your online store.

Commerce

Service

 
Desk

Helpdesk software to deliver great customer support.

Desk
 
Assist

Remote support and unattended remote access software.

Assist
 
Lens

Interactive remote assistance software with augmented reality.

Lens
 
FSM

End-to-end field service management platform for service businesses.

FSM
 
SalesIQ

Live chat app to engage and convert website visitors.

SalesIQ
 
Voice

Cloud Contact Center Software for businesses.

Voice
 
NEW
Solo

The all-in-one toolkit for solopreneurs.

Solo
 
Bookings

Appointment scheduling app for consultations with customers.

Bookings
 
Suites
Service Plus

Unified platform for customer service and support teams.

Service Plus

Finance

 
Books

Powerful accounting platform for growing businesses.

Books
 
FREE
Invoice

100% Free invoicing solution.

Invoice
 
Expense

Effortless expense reporting platform.

Expense
 
Inventory

Powerful stock management and inventory control software.

Inventory
 
Billing

End-to-end billing solution for your business.

Billing
 
Checkout

Collect payments online with custom branded pages.

Checkout
 
NEW
Payroll

Payroll software with automated tax payments and filing.

Payroll
 
NEW
Solo

The all-in-one toolkit for solopreneurs.

Solo
 
Practice

Practice management software for accounting firms.

Practice
 
Sign

Digital signature app for businesses.

Sign
 
Commerce

eCommerce platform to manage and market your online store.

Commerce
 
Suites
Finance Plus

All-in-one suite to manage your operations and finances.

Finance Plus

Email and Collaboration

 
Mail

Secure email service for teams of all sizes.

Mail
 
Meeting

Online meeting software for all your video conferencing & webinar needs.

Meeting
 
Writer

Word processor for focused writing and discussions.

Writer
 
Sheet

Spreadsheet software for collaborative teams.

Sheet
 
Show

Create, edit, and share slides with a sleek presentation app.

Show
 
Notebook

Beautiful home for all your notes.

Notebook
 
Cliq

Stay in touch with teams no matter where you are.

Cliq
 
Connect

Employee experience platform to communicate, engage, and build positive employee relations.

Connect
 
Bookings

Appointment scheduling app for consultations with customers.

Bookings
 
TeamInbox

Shared inboxes for teams.

TeamInbox
 
WorkDrive

Online file management for teams.

WorkDrive
 
Sign

Digital signature app for businesses.

Sign
 
Office Suite

Powerful collaborative work platform for teams.

Office Suite
 
Office Integrator

Built in document editors for web apps.

Office Integrator
 
ZeptoMail

Secure and reliable transactional email sending service.

ZeptoMail
 
Calendar

Online business calendar to manage events and schedule appointments.

Calendar
 
Learn

Knowledge and learning management platform.

Learn
 
Voice

Cloud Contact Center Software for businesses.

Voice
 
ToDo

Collaborative task management for individuals and teams.

ToDo
 
Tables

Work management tool to connect people, processes, and information.

Tables
 
FREE
PDF Editor

Collaborative online PDF editing tool.

PDF Editor
 
Suites
Workplace

Application suite built to improve team productivity and collaboration.

Workplace

Human Resources

 
People

Organize, automate, and simplify your HR processes.

People
 
Recruit

Intuitive recruiting platform built to provide hiring solutions.

Recruit
 
Expense

Effortless expense reporting platform.

Expense
 
Workerly

Manage temporary staffing with an employee scheduling solution.

Workerly
 
NEW
Payroll

Payroll software with automated tax payments and filing.

Payroll
 
Shifts

Employee scheduling and time tracking app.

Shifts
 
Sign

Digital signature app for businesses.

Sign
 
Suites
People Plus

Comprehensive HR platform for seamless employee experiences.

People Plus

Security and IT Management

 
Creator

Build custom apps to simplify business processes.

Creator
 
Directory

Workforce identity and access management solution for cloud businesses.

Directory
 
FREE
OneAuth

Secure multi-factor authenticator (MFA) for all your online accounts.

OneAuth
 
Vault

Online password manager for teams.

Vault
 
Catalyst

Pro-code platform to build and deploy your apps.

Catalyst
 
Toolkit

Complete resource for any admin-related lookup queries.

Toolkit
 
Lens

Interactive remote assistance software with augmented reality.

Lens
 
Assist

Remote support and unattended remote access software.

Assist
 
QEngine

Test automation software to build, manage, execute, and report testcases.

QEngine
 
NEW
RPA

Automate manual, tedious, and repetitive tasks easily.

RPA

BI and Analytics

 
Analytics

Modern self-service BI and analytics platform.

Analytics
 
Embedded BI

Embedded analytics and white label BI solutions, tailored for your needs.

Embedded BI
 
DataPrep

AI-powered data preparation service for your data-driven organization.

DataPrep
 
NEW
IoT

Harnessing IoT analytics for real-time operational intelligence.

IoT

Project Management

 
Projects

Manage, track, and collaborate on projects with teams.

Projects
 
Sprints

Planning and tracking tool for scrum teams.

Sprints
 
BugTracker

Automatic bug tracking software for managing bugs.

BugTracker
 
NEW
Solo

The all-in-one toolkit for solopreneurs.

Solo

Developer Platforms

 
Creator

Build custom apps to simplify business processes.

Creator
 
Flow

Automate business workflows by creating smart integrations.

Flow
 
Catalyst

Pro-code platform to build and deploy your apps.

Catalyst
 
Office Integrator

Built in document editors for web apps.

Office Integrator
 
ZeptoMail

Secure and reliable transactional email sending service.

ZeptoMail
 
QEngine

Test automation software to build, manage, execute, and report testcases.

QEngine
 
Tables

Work management tool to connect people, processes, and information.

Tables
 
NEW
RPA

Automate manual, tedious, and repetitive tasks easily.

RPA
 
NEW
Apptics

Application analytics for all apps.

Apptics
 
Embedded BI

Embedded analytics and white label BI solutions, tailored for your needs.

Embedded BI
 
NEW
IoT

Build, deploy, and scale IoT solutions for connected businesses.

IoT
 
DataPrep

AI-powered data preparation service for your data-driven organization.

DataPrep

IoT

 
NEW
IoT

Low-code IoT platform and solutions for connected businesses.

IoT

Search Result

 
CRM Plus

Unified platform to deliver top-notch customer experience.

Try now
CRM Plus
 
Service Plus

Unified platform for customer service and support teams.

Try now
Service Plus
 
Finance Plus

All-in-one suite to manage your operations and finances.

Try now
Finance Plus
 
People Plus

Comprehensive HR platform for seamless employee experiences.

Try now
People Plus
 
Workplace

Application suite built to improve team productivity and collaboration.

Try now
Workplace
 
Marketing Plus

Unified marketing platform for marketing teams.

Try now
Marketing Plus
 
All-in-one suite

Zoho One

The Operating System for Business

Run your entire business on Zoho with our unified cloud software, designed to help you break down silos between departments and increase organizational efficiency.

TRY ZOHO ONE
Zoho One
Zoho Marketplace

With over 2000 ready-to-use extensions across 40+ categories, connect your favorite business tools with the Zoho products you already use.

EXPLORE MARKETPLACE
Marketplace

Zoho Analytics has been recognized in the 2024 Gartner® Magic Quadrant™ for ABI PlatformsRead more

Skip to main content

Chart Types Primer

You can create various types of charts such as Area, Bar, Bubble, Line, Pie, Stacked, Scatter, Funnel, Web and 3D charts by simply dragging and dropping the required columns into the respective shelves in the design area.

Before we proceed any further into understanding the chart types and the combination of columns that can be used to create them, it is necessary that we first know about the functions associated with each column.

Listed below are the associated functions used in Zoho Analytics:

  • Dimension: a column that has discrete values (eg. String and date column).
  • Aggregate: a column with an aggregate function applied contains aggregate values like sum, average etc. This even includes aggregate formula columns.
  • Measure: Measure column is nothing but a column containing numerical values that can be measured.

The chart designer looks as shown below. You can create charts by simply dragging and dropping the columns in their respected shelves. To know much more in detail about creating charts, you can refer to this help documentation.

 

The chart types that are not applicable for the combination of columns that you use while creating the chart will appear faded (disabled). Let us now see in detail about each chart type and the combination of column types used to create them.

 Pie Chart

Pie charts are used to represent percentage or proportional data. A pie chart can be converted to any of its equivalents like ring chart, funnel chart, bar chart, line chart, scatter chart, area chart or web chart.

Given below is a combination of column types which when dropped in the mentioned shelves will help you generate a pie chart.

 X axisY axisColorTextTooltip
Case 1DimensionAggregate--Aggregate/ Measure/ OptionalAggregate/ Measure/ Optional
Case 2Dimension/ AggregateOptional--Aggregate/ Measure/ OptionalAggregate/ Measure/ Optional
Case 3OptionalAggregate/ Dimension--Aggregate/ Measure/ OptionalAggregate/ Measure/ Optional

Example: Region vs Profit.

Example: Requests by status

 Ring Chart

Ring chart or otherwise called as a doughnut chart is used to represent data in rings. A ring chart displays the contribution of each value to the overall total expressed in percentage. Ring chart can be converted to any of its equivalents like pie chart, funnel chart, bar chart, line chart, scatter chart, area chart or web chart.
Given below is a combination of column types which when dropped into their respective shelves as mentioned will generate a ring chart.

 X axisY axisColorTextTooltip
Case 1DimensionAggregate--Aggregate/ Measure/ OptionalAggregate/ Measure/ Optional
Case 2Dimension/ AggregateOptional--Aggregate/ Measure/ OptionalAggregate/ Measure/ Optional
Case 3OptionalAggregate/ Dimension--Aggregate/ Measure/ OptionalAggregate/ Measure/ Optional

Example: Region-wise sales%

Example: Requests by status

 Bar Chart

Bar charts are used when you have to compare data classified into discrete groups. They are generally used to categorize data or represent two or more metrics of a particular category. They display values as individual bars whose height is determined by the value plotted and grouped by each category. A Bar chart can be converted into any of its equivalents like Line, Scatter, Area, Stacked Bar, Stacked Area or Combo chart depending on the category.

The below combination of column types will help you create a bar chart.

 X axisY axisColorTextTooltip
Case 1DimensionAggregateDimension/ Aggregate/ Measure/ OptionalAggregate/ Measure/ OptionalAggregate/ Measure/ Optional
Case 2DimensionMultiple Aggregate fieldsDimension/ Aggregate/Measure/ OptionalAggregate/ Measure/ OptionalAggregate/ Measure/ Optional
Case 3Dimension/ AggregateOptionalAggregate/Measure/ OptionalAggregate/ Measure/ OptionalAggregate/ Measure/ Optional
Case 4OptionalDimension/ AggregateAggregate/Measure/ OptionalAggregate/ Measure/ OptionalAggregate/ Measure/ Optional

Example: Product Category wise sales

Example: Requests count by month

Butterfly Chart

A butterfly chart is a type of bar chart that can be used to compare two different data sets. Also known as a Tornado or Divergent chart, this chart plots the data as two horizontal bars with the X-axis in the center, thereby resembling butterfly wings. 

The following combination of column types allows you to create a butterfly chart. 

 

X axis

Y axis

Color

Text

Tooltip

Case 1

Dimension

Aggregate

Dimension

Aggregate / Optional

Aggregate / Optional

Case 2

Dimension

Multiple Aggregate fields

-

Aggregate / Optional

Aggregate / Optional

To learn more about Butterfly charts, click here

 Stacked Chart

A Stacked chart allows you to easily analyze the patterns and trends in your data by comparing the parts of your dataset to the whole. In other words, it plots the contribution of each value to the total across categories. There are two types of stacked charts - Stacked Bar and Stacked Area.

Stacked Bar Chart

You can use the below combination of columns to create a stacked bar chart.

 X axisY axisColorTextTooltip
Case 1DimensionAggregate

Dimension/ Aggregate/Measure

Dimension/ Aggregate/ OptionalDimension/ Aggregate/ Optional
Case 2OptionalDimension/ Aggregate

Dimension/ Aggregate/Measure

Dimension/ Aggregate/ OptionalDimension/ Aggregate/ Optional
Case 3Dimension/ AggregateOptionalDimension/ Aggregate/MeasureDimension/ Aggregate/ OptionalDimension/ Aggregate/ Optional

Example: Quarter wise sales for each region.

Example: Priority-wise requests for each region.

Stacked Area Chart

You can use the below combination of columns to create a stacked area chart.

 X axisY axisColorTextTooltip
Case 1DimensionAggregateDimension/ Aggregate/ MeasureAggregate/ Optional--
Case 2DimensionMultiple Aggregate fields--Aggregate/ Optional--

Example: Yearly profit obtained for each product category

Example: Mode-wise ticket in-flow by weekday

 Scatter Chart

Scatter charts are commonly used for plotting and comparing numeric values, such as scientific, statistical, and engineering data. It is generally used for comparison between two numerical axes with uneven intervals and ranges. You can interchange a scatter chart with a line chart.

The following combination of column types will help you generate a scatter chart.

 X axisY axisColorTextTooltip
Case 1DimensionAggregate/ DimensionAggregate/ Dimension/ Measure/ Optional

Aggregate/ Dimension/ Measure/ Optional

Aggregate/ Dimension/ Measure/ Optional

Case 2AggregateAggregate/ DimensionAggregate/ Dimension/ Measure/ Optional

Aggregate/ Dimension/ Measure/ Optional

Aggregate/ Dimension/ Measure/ Optional

Case 3Dimension/ AggregateOptionalAggregate/ Dimension/ Measure/ Optional

Aggregate/ Dimension/ Measure/ Optional

Aggregate/ Dimension/ Measure/ Optional

Case 4Aggregate/ DimensionOptionalAggregate/ Dimension/ Measure/ Optional

Aggregate/ Dimension/ Measure/ Optional

Aggregate/ Dimension/ Measure/ Optional

Example: Temperature Vs Rainfall

Example: Technician Load

 Line Chart

A line chart is used to analyze series trend across a time period. You can interchange a line chart with a scatter chart.

Any of the below combination of column types will generate a line chart.

 X axisY axisColorTextTooltip
Case 1DimensionAggregate/ Dimension/ OptionalDimension/ Aggregate/ Measure/ OptionalDimension/ Aggregate/ Measure/ OptionalDimension/ Aggregate/ Measure/ Optional
Case 2OptionalAggregate/ DimensionDimension/ Aggregate/ Measure/ OptionalDimension/ Aggregate/ Measure/ OptionalDimension/ Aggregate/ Measure/ Optional
Case 3Aggregate/ DimensionOptionalDimension/ Aggregate/ Measure/ OptionalDimension/ Aggregate/ Measure/ OptionalDimension/ Aggregate/ Measure/ Optional

Example: Running Sales vs Cost vs Profit.

 Bubble Chart

Bubble charts are really useful if you want to visualize your data highlighting the magnitude/weight of a data point with sizing. You can use a bubble chart wherever a Scatter plot is used, with scatters points being replaced by bubbles. The size of the bubble will be determined by the data column dropped in the new Size shelf of the Chart designer.

The following combination of column types will help you generate a bubble chart.

 X axisY axisColorTextSizeTooltip
Case 1DimensionAggregate/ DimensionAggregate/ Dimension/ Measure/ OptionalAggregate/ Dimension/ Measure/ OptionalAggregate

Aggregate/ Dimension/ Measure/ Optional

Case 2AggregateAggregate/ DimensionAggregate/ Dimension/ Measure/ Optional

Aggregate/ Dimension/ Measure/ Optional

Aggregate

Aggregate/ Dimension/ Measure/ Optional

Case 3DimensionOptionalAggregate

Aggregate/ Dimension/ Measure/ Optional

Aggregate

Aggregate/ Dimension/ Measure/ Optional

Case 4AggregateOptionalDimension

Aggregate/ Dimension/ Measure/ Optional

Aggregate

Aggregate/ Dimension/ Measure/ Optional

Case 5OptionalDimensionAggregate

Aggregate/ Dimension/ Measure/ Optional

Aggregate

Aggregate/ Dimension/ Measure/ Optional

Case 6OptionalAggregateDimension

Aggregate/ Dimension/ Measure/ Optional

Aggregate

Aggregate/ Dimension/ Measure/ Optional

Example: Sales of each State by Product Category

The Packed Bubble chart type is used to display data in a cluster of circles or bubbles. They are used to display the values disregarding the axes. The difference between a normal bubble chart and a packed bubble is that the latter is tightly packed rather than spread over a grid. You can use a packed bubble chart to visualize large amount of data in a small space.

The following combination of column types will help you generate a packed bubble chart.

 X axisY axisColorTextSizeTooltip
Case 1DimensionAggregate/ DimensionAggregate/ Dimension/ Measure/ OptionalAggregate/ Dimension/ Measure/ OptionalAggregate

Aggregate/ Dimension/ Measure/ Optional

Case 2AggregateAggregate/ DimensionAggregate/ Dimension/ Measure/ Optional

Aggregate/ Dimension/ Measure/ Optional

Aggregate

Aggregate/ Dimension/ Measure/ Optional

Case 3DimensionOptionalAggregate

Aggregate/ Dimension/ Measure/ Optional

Aggregate

Aggregate/ Dimension/ Measure/ Optional

Case 4AggregateOptionalDimension

Aggregate/ Dimension/ Measure/ Optional

Aggregate

Aggregate/ Dimension/ Measure/ Optional

Case 5OptionalDimensionAggregate

Aggregate/ Dimension/ Measure/ Optional

Aggregate

Aggregate/ Dimension/ Measure/ Optional

Case 6OptionalAggregateDimension

Aggregate/ Dimension/ Measure/ Optional

Aggregate

Aggregate/ Dimension/ Measure/ Optional

Example: Sales across each year by region

Example: Region-wise Sales metric for each Quarter

Bubble Pie Chart

Bubble Pie Chart is a combination of pie and bubble charts. This is useful when you need to compare data with multiple variables. The following combination of column types allows you to create a bubble pie chart.

 X axisY axisSizeColorTextTooltip
Case 1DimensionAggregateAggregateDimensionAggregate/ 
Optional
Optional
Case 2DimensionMultiple Aggregate fieldsAggregate--Aggregate/ 
Optional
Optional
 

Combination Chart

The combination chart is a combination of two or more types of charts. You can combine bar, line, area, bubble and scattered in one chart, which is useful when you wish to represent varied data. 

The following combination of column types can be used to create a combination chart.

 X axisY axisColorTextTooltip
Case 1DimensionMultiple Aggregate fields--OptionalOptional
Case 2DimensionAggregate DimensionOptionalOptional

Example: Profit, Sales and Cost across Years

To create a Combination chart, navigate to the Combination tab of the chart Settings page. Select the type of combination chart from the Select a combo chart type drop down, assign a chart type for each data series using the Series section, choose the required chart style using the Select the style of the chart drop down, and click Apply.

Area Chart

Area charts shade the area beneath the lines and therefore help you more readily to compare data magnitudes. They are mainly useful for emphasizing the change in metrics across time. You can interchange an area chart with a web chart.

Given below is a combination of column types which will help you generate an area chart.

 X axisY axisColorTextTooltip
Case 1DimensionAggregateDimension/ Aggregate/ Measure/ Optional----
Case 2DimensionAggregateDimension/ Aggregate/ Measure/ OptionalAggregateAggregate

Example: Escalation trend by month and year

Example: Year wise Sales

 Funnel Chart

The funnel chart is used to represent a progressive flow/reduction of a business metric across phases.

The below combination of column types can be used to create a funnel chart.

 X axisY axisColorTextTooltip
Case 1DimensionAggregate--Aggregate/ Measure/ OptionalAggregate/ Measure/ Optional
Case 2OptionalAggregate--Aggregate/ Measure/ OptionalAggregate/ Measure/ Optional

Example: Sales Pipeline - To visualize potentials across each stage

 Web Chart

Web charts help in studying the comparison between different data series. It compares the values of a number of data series represented with data markers in proportion with a center point.

Given below is a combination of column types which will help you generate an web chart.

 X axisY axisColorTextTooltip
Case 1DimensionAggregateDimension/ Optional--Aggregate/Measure/ Optional

Example: Cost Vs Sales for 2016

Map chart

A map chart can be used to tag metrics against geographical locations on a map view. You can create map charts using location specific columns in your data. This location information can be continent, country, county, state/province, city, or latitude and longitude.

Here's a table with possible combinations of column types to create map charts: 

 RegionX-axisY-axisColorTextTooltip
 Type               Geo locationAggregateDimension/ Aggregate/ Measure (Optional)Dimension/ Aggregate/ Measure (Optional)Aggregate/ Dimension/ Measure (Optional)

Note: To export a map chart, ensure that Google Chrome version 59 or above is installed in your workstation. 

The following is a map chart that depicts the country-wise distribution of sales.

 filled-map

To learn more about map charts, click here.

Heat Map Chart

Heat map is a chart that displays data values as colors inside a matrix. This is a two-dimensional grid chart, where each color represents the data.

You can also choose to derive the size and color intensity of each cell based on the data. This will be pretty useful for categorizing and visualizing data based on factors like the volume of occurrence, intensity, performance scale (bad to good) etc., 

The following combination of column types can be used to create a combination chart.

 X Axis Y AxisColorTextTooltip
Case 1DimensionDimensionAggregate

Aggregate

(Optional)

Aggregate

(Optional)

Example: Sales across a Year by Month and Week. 

 X axisY axisSizeColorTextTooltip
Case 1DimensionAggregateAggregateDimensionAggregate/ 
Optional
Optional
Case 2DimensionMultiple Aggregate fieldsAggregate--Aggregate/ 
Optional
Optional
 

Histogram

A histogram is a variation of bar chart where, instead of plotting values over discrete intervals, the values are plotted over continuous categories. Histogram charts are useful in plotting frequency distributions. 

The following combination of column types can be used to create histogram charts:

 X Axis Y AxisColorTextTooltip
Case 1DimensionAggregate/
Optional
--

-

Case 2OptionalAggregate---
Case 3Aggregate/
Optional
Dimension---
Case 4AggregateOptional---
x
Thanks for your interest. We shall get back to you shortly.