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

Creating Chart

Zoho Analytics provides an easy to use drag and drop interface to create charts fast & easy. You can create various types of charts, including Bar, Line, Pie, Bubble, Packed Bubble, Stacked, Scatter, Area, Combination, Funnel, Web, etc., by dragging and dropping the required columns into the respective shelves in the design area. 

Watch the below video to get an overview on creating Charts.

You can change the chart type any time without having to recreate it. You can also apply the appropriate aggregate functions on the columns to calculate and summarize data the way you want it.

Creating a chart

You can invoke the chart designer in one of the following ways:

  1. From the Side navigation panel

    • Access the workspace and click Create in the top left corner and choose Chart View from the drop-down menu.


      (or)

    • Click Reports from the side navigation panel and click Create New Reports and choose Chart View from the list.

    • Choose the base table above which the reports should be created.
  2. From the Table interface
    • Open the table over which the report should be created.
    • Click the more icon and choose New Chart view from the list.
  3. On the left is the Column List pane, and on the right is the Chart Designer area.
  4. Drag-and- drop the required columns into the respective shelves
    • X-Axis: Column dropped in this shelf appears horizontally across the X-axis.
    • Y-Axis: Column dropped in this shelf appears vertically across the Y-axis. You can drop multiple columns in this shelf to create charts with multiple Y-axes.
    • Color: When a column is dropped in this shelf, the chart will be further categorized showing each data point in different colors (different data series) in the chart.
    • Text: Includes the corresponding value of the dropped column as a data label in the chart, according to the function applied on the column.
    • Include columns for Tooltip: Includes the corresponding value of the dropped columns in the chart tool-tip, according to the function applied on the column. 

Zia Suggestions

Choosing the appropriate chart type can be challenging. With Zia's suggestions, you can find the right visualizations that are best suited for the data.
These suggestions will be available once the columns are dropped on the designer shelf. 

  1. Click Zia Suggestions at the top left corner above the chart designer.
  2. Zia Suggestions will list all the suitable chart types based on the fields (dimensions and measures) dropped in the designer shelf. 
  3. You can preview the charts and choose the most preferred one. Refer to choose the right visualization article to learn more. The Preview page will also list the steps to create the chosen chart type. 
  4. Click Apply to use the report for analysis.

Undo and Redo

The Undo option helps reverse a single or multiple action in the order of execution. The Redo option helps repeat a recent action that was undone. These options can be found on the upper-left corner of the chart editor.

Applying Functions on Columns

Zoho Analytics allows you to apply aggregate/categorical functions like Sum, Count, Average, Min, Max, etc., on the data columns to a group and summarize data in charts. When you apply a function on a column, a single value will be returned which is derived based on the values in the column. The default function for a Numeric (including Currency) data type is Sum and for a Date data type is Year. If the data type of the column is a string (Categorical/Dimension column) and not numeric, then the default function applied is Actual Values.

To change the default function applied, after dropping the column, select the required function (aggregate/categorical) from the drop-down list present in the column. The drop-down list displays all the applicable functions based on the data type of the column, as shown in the screenshots below.

String Data Type

Numeric Data Type

Date Data Type

For instance, if you want to plot Average Sales for each Month across each Region, select Average function from the drop-down list for Sales (Y Axis) column, Month & Year function for Date (X Axis) column and select Actual Values function for Region (Color column) and then click on the button 'Click here to Generate Graph'.

The following tables list all the functions along with the description of their functionality.

Numeric and Currency Data Types:

Function Description
SumReturns the sum of all the values in the column. The summation will be done at each category/group level shown in the report.
Maximum [Max]Returns the maximum value in the column.
Minimum [Min]Returns the minimum value in the column.
Average [Avg]Returns the average of all the values in the column.
Standard deviationReturns standard deviation derived based on all values in the column.
MedianReturns the middle value of the column.
ModeReturns the value that occurs most often in the column.
PercentileReturns the percentile of the column. by default, the 50th percentile will be returned. You can change this as needed. 
e.g., the 90th percentile of a column is a number which has 90% of the column values below it.
VarianceReturns the variance of the column.
CountReturns the count of the number of values in the column.
Distinct CountReturns the count of the number of distinct values in the column.
MeasureTreats the values in the column as a measurable numeric value. Returns each distinct value present as a numeric value to be plotted in the report.
DimensionTreats the values in the column as a textual (categorical/dimensional) value. Returns each distinct value present as a text value to be plotted in the report.
RangeGroups the entire range of numeric values present in the column into multiple ranges.. e.g., if your data range is between 0 to 1000 then it will be grouped as 0 to 100, 101 to 250 ... 901-1000. You can also specify the custom range size to group the data using the Add New Range link. i.e.,if you set the range size as 50, then it will be grouped as 0 to 50, 51 to 100 ....

Date Data Type - Actual Value Functions:

FunctionDescription
YearReturns all distinct year values present in the column. E.g.,2003, 2010
Quarter & YearReturns all distinct quarter & year values present in the column. E.g., Q1 2010
Month & YearReturns all distinct month & year values present in the column. E.g., March 2010
Week & YearReturns all distinct week of the year values present in the column. E.g., W1 2010
Full DateReturns all distinct dates present in the column. E.g., 1/1/2011
Date & TimeReturns all distinct date and time pairs present in the column. E.g. 01/12/2010 00:10:07 hrs

Date Data Type - Seasonal Value Functions:

FunctionDescription
QuarterHelps identifying seasonal trends based on quarters present across all years in the column. E.g., Q1, Q2.
MonthHelps identifying seasonal trends based on months across all years. E.g., January, February.
WeekHelps identifying seasonal trends based on weeks across all years. E.g., Week 1, Week 2.
Week DayHelps to identify seasonal trends based on weekday across all years. E.g., Sunday, Monday.
Day of MonthHelps identifying seasonal trends based on day of month across all dates. E.g., 1 to 31.
Hour of DayHelps identifying trends across hours in a day. E.g., 0 to 23hrs.

Date Data Type - Aggregate Function:

FunctionDescription
CountReturns the number of date values in the column.
Distinct CountReturns the number of distinct date values in the column.

String(Categorical/Dimension) Data Type:

FunctionDescription
Actual ValuesAll the distinct values in the column will be listed.
CountNumber of values in the column will be listed.
Distinct CountNumber of distinct values in the column will be listed.

Advanced Summarizing Options

When creating a chart, Zoho Analytics provides advanced summary functions, apart from the basic functions such as Sum, Max, Min or Average. This allows you to summarize data values in that column based on the values in other columns. Using this you will be able to do some powerful calculations on a chart like running total of sales over years or calculate the difference in sales from the previous year etc.,

Dependent Fields

While creating a report, advanced functions like Running Total and the difference from function are applied over a base column like date and categories. Zoho Analytics allows you to move or reorder the dependent columns to other fields like Color, Text, Size, and Tooltip in the chart editor. However, the removal of a dependent column is not allowed. An alert message will be displayed while trying to remove a dependent column.

The below table tabulates the advanced functions available in Zoho Analytics

FunctionDescription
NormalDisplays the calculated value of the aggregate function applied over the column. By default this option will be selected.
% of TotalDisplays the percentage of the grand total of all the data in the chart series.
Running TotalDisplays data in successive data points of the chart as a running total, based on the selected Base Field.
Difference FromDisplays the data in each data point as the difference from the value in the previous data point, based on the selected Base Field.
% of Previous ValueDisplays the data in each data point as a percentage of the value in the previous data point, based on the selected Base Field.
% of Difference FromDisplays the data in each data point as a percentage of differences from the value in the previous data point, based on the selected Base Field.
100% GroupDisplays the percentage of the data point value in total of the group, based on the selected Base Field. This will be useful while creating 100% Stacked Bar and 100% Stacked Area Chart.
When you create a chart for sales across years categorized by region, then using this function you could get the percentage of sales in each region as seen the example at the left.
Moving AverageDisplays the calculated moving value of each data point based on the inputs you provide. The summary function selected will be taken as the base for calculation. You can perform  sum, average, minimum and maximum calculation using this.
This will be useful to visualize the trend of the your data. The example at the left illustrate the impression of your website vs. moving average of the impressions for the last 30 days.

The following screenshot illustrates a sample chart with different advanced summary functions applied.

Choosing Chart Type

After creating a chart, you can easily change it to another chart type by simply clicking on a button with out changing the plotted data. For example, you have created a Bar chart, but then decide that you want the data to be displayed as a Pie chart. You can do this by changing the chart type using the toolbar or you can use Other Charts button on the toolbar.

The toolbar provides you with the options to choose between Pie, Bar, Stacked Bar, Line, Scatter and Table chart types at the top level. If you do not find the chart type that you are looking for, then click on Other Charts button in the toolbar and select the chart type that you want to apply from the Chart Options dialog box that appears. You can view a brief description of each chart type the bottom of the dialog box by clicking on the specific chart type. Notice that chart types that are not applicable/unsupported for the combination of columns that you are using to create the chart will appear disabled.
After selecting the required chart type in the dialog box, click OK.

The below table describes the various Chart types supported by Zoho Analytics. For a detail understanding of the chart types and the combination of columns used to create them, refer to this help documentation.  

Chart TypeDescription
PiePie chart is a circular chart divided in to slices. It plots the contribution of each value to the overall total expressed in percentage.
RingRing chart plots the data in a ring. It displays the contribution of each value to the overall total expressed in percentage.
FunnelFunnel chart plots series of data in a funnel shape. Useful to plot values in a process/stage oriented data set.
BarBar (Column) chart plots the data as sets of vertical bars. Displays values as individual bars whose height is determined by the value plotted and grouped by each category
StackedStacked bar chart plots the contribution of each value to the total across categories.
ScatteredScattered chart plots values as a set of points.
LineLine chart displays data as a series of points connected by a line.
Line with PointsIt is a Line chart with markers displayed at each data point.
StepStep chart is similar to the line chart where data points are connected by steps (up or down) instead of straight lines.
Smooth LineSmooth Line chart connects the data points with a smooth curve.
Smooth Line with PointsThis is a Smooth Line Chart with markers displaying the data point.
Combo BarCombination chart compares value across categories. Combo Bar is a combination of bar and line chart.
 
Combo Stacked Combo Stacked is a combination of stacked bar and line chart.
Smooth Line Bar ComboSmooth line chart can also be applied in Combination charts using the Use Smooth Line check box. Combo Bar and Smooth Line is a combination of bar and smooth line chart.
Smooth Line Stacked ComboCombo Stacked and Smooth Line is a combination of stacked bar and smooth line chart.
AreaArea charts is similar to a line chart, but with all the area below the line filled with a color.
Area with Points It is an Area chart with markers displayed at each data value point plotted.
Smooth Line AreaIt is an Area chart with a smoorth line.
Smooth Line Area with PointsIt is an smooth line Area chart with markers displayed at each data value point plotted.
Stacked AreaStacked Area chart is an Area chart, where the contribution of each data series is stacked over the previous one
Stacked Area with PointsIt is a Stacked Area chart with markers displayed at each data point.
Smooth Line Stacked AreaIt is a Stacked Area chart with Smooth Line.
Smooth Line Stacked AreaIt is a Smooth Line Stacked Area chart with markers displayed at each data point.
BubbleHighlights the data based on the magnitude in the form of bubbles.
Packed BubblePacked Bubble chart type is used to display data in a cluster of circles or bubbles disregarding the axes
Filled WebFilled Web is a two-dimensional chart of three or more quantitative variables represented on axes starting from the same point.
WebWeb Chart displayed without filling color shade.
Map - ScatterPlots the locations in the map using a scatter chart.
Map - PiePlots the values in the map using a pie chart.
Map - BubblePlots the values in the map using a bubble chart.
Map - Bubble PiePlots the values in the map using both a pie and a bubble chart.
Map - FilledFills the map area with colors depending on the data

Until recently Zoho Analytics had both 2D as well as 3D charts. But, having analyzed the usefulness of 3D charts deeper especially from the user experience point of view, we have decided to completely stop the support for 3D charts. Click here to learn more.

x
Thanks for your interest. We shall get back to you shortly.