Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements that can help you format and add additional details to your charts based on how you'd like to visualize the data.
A trendline is one of the chart elements that helps you visualize the general direction or trend of the data points plotted on the chart. It helps you observe the overall movement, pattern, or tendency of data over time to support analysis and forecasting. For example, let's take a chart indicating the sales of product X increasing over the given number of years. By adding trendlines to your chart, you can easily deduce the increasing sales.
What are the different types of trendlines and when should you use them?
- Linear
- Power
- Exponential
- Logarithmic
- Polynomial
- Moving average
Linear
Linear trendlines are suitable for data sets that indicate a steady increase or decrease over a given period of time and are often straight lines.
In this example, an employee's annual salary has steadily increased in relation to their work experience, indicating a linear trendline.
Power
Power trendlines are helpful in predicting data sets that increase at a regular interval and result in a curved line.
In this example, the number of people following a Twitter account has increased rapidly over the course of a year.
Exponential
Exponential trendlines form a curved line representing values that increase or decrease at an accelerating rate. It's used for data with exponential growth or decay.
In this example, bicycle usage decreases rapidly over the given years.
Logarithmic
Logarithmic trendlines are suitable to represent data sets that show an increase or decrease and then gradually stabilize.
In this example, the person's height increases as he grows and then levels out as he reaches maturity.
Polynomial
Polynomial trendlines are appropriate capturing complex relationships between variables in data sets that keep oscillating or have intricate fluctuations.This type of trendline is classified into different types based on the degree or order. In Zoho Sheet, you can select the degree of the polynomial (2 to 10) based on how perfectly the trendline fits the given data set.
In this example, electricity consumption gradually increases and then decreases over the given months.
Moving average
The moving average trendline takes the fluctuations in the given values, averages them, and uses the average values to plot the trendline.
Moving average trendlines are useful for showing the overall trajectory of data sets with a lot of ups and downs.
The stock market is a perfect match for the moving average trendline because stocks generally fluctuate on a regular basis.
Zoho Sheet offers multiple chart elements, like trendlines, data labels, legends, and gridlines, to help you customize the way your charts visualize information and ideas. You can also check out our post on the 3 important chart customizations.
Follow our Tips and Tricks forum to explore similar tips on using Zoho Sheet for your business. You can also join our community to stay informed on the latest updates and feature enhancements.
Recent Topics
Sharedmail box access via an api
Hi, I am trying to access a sharedmailbox via an API. I am the moderator and creator of this shared mailbox. I have created a self client but when when i try to get list of all emails, it does not list the sharedmailbox. Help me to resolve this or provide
Duplicate Record Creation
Hello Team, I would like to check whether there are any options available in Zoho FSM to prevent duplicate record creation in the following modules: Assets Companies Contacts Ideally, we would like the system to check for existing records before allowing
automatic email reminder
in need of an email reminder to participants having trained for a course but have not paid
Hiding old CRM Contacts in Desk
I have an issue with contacts in Desk. We sync contacts from CRM with DESK and we have old contacts, eg staff members that have left businesses. The issue is when adding a ticket (most of our tickets are raised over the phone), staff sometimes pick
CC'd User Receiving Both Regular Email Chain Response & Reply Notification
Hi, I am trying to set up the notifications for users and I'm a bit confused. I'm testing with personal accounts and my Desk agent, and I'm noticing that CC'd users are receiving both the regular email chain that the requester (contact) receives, but
Default View for Email Sent
Hi, can the default view for email sent to candidates be "ALL" instead of the current user? I have to click the dropdown menu every time so that I can see if other recruiters have already sent an email to a candidate. Thanks!
KB Articles - Can't See Content or Trigger Immediate Sync
Once a file has been submitted to the KB, there's no way to check what it actually contains. There's also no way to force an immediate sync with the source document. These are issues when one is developing and testing an agent. It makes troubleshooting
Enable Screen Recording in Zoho WorkDrive Mobile Apps (Android & iOS)
Hi Zoho WorkDrive Team, How are you? We are enthusiastic Zoho One users and rely heavily on Zoho WorkDrive for internal collaboration and content sharing. The screen-recording feature in the WorkDrive web app (similar to Loom) is extremely useful- however,
Ability to Set Text Direction for Individual Cells in Zoho Sheet
Dear Zoho Sheet Team, We hope you are doing well. We would like to request an enhancement in Zoho Sheet that allows users to set the text direction (right-to-left or left-to-right) for individual cells, similar to what is available in Google Sheets. Use
Add Comprehensive Accessibility Features to Zoho Writer
Hello Zoho Writer Team, We hope you are doing well. We would like to submit a feature request to enhance Zoho Writer with a full set of accessibility tools, similar to the accessibility options already available in the Zoho Desk agent interface. 🚧 Current
Problem with currency field in Zoho CRM
Hi Guys Zoho Books has a feature in currency fields that automatically converts decimal numbers with commas ( , ) to period format ( . ) when pasting them. For example: R$ 2,50 --> R$ 2.50 Is this behavior available in Zoho CRM? I couldn't find any configuration
Ability to Attach Images When Reporting Issues to Zoho Projects from Zoho Desk
Hi Zoho Desk Team, Hope you’re doing well. We’re using the Zoho Desk–Zoho Projects integration to report bugs directly from support tickets into the Zoho Projects issue tracker. This integration is extremely useful and helps us maintain smooth coordination
Make Camera Overlay & Recording Controls Visible in All Screen-Sharing Options
Hi Zoho WorkDrive Team, Hope you are doing well. We would like to request an improvement to the screen-recording experience in Zoho WorkDrive. Current Limitation: At the moment the recording controls are visible only inside the Zoho WorkDrive tab. When
VENDORS ARE NOT SYNCHED WITH CONTACTS IN CRM
Hello, While the ACCOUNTS and CONTACTS (Including the primary contact) are synced with the CONTACTS module in CRM, the vendor's CONTACTS are not synced with CRM - which basically forces the users to re-enter all vendor's contacts twice and then update
Properly Capture Dropdowns & Hover Elements When Recording a Window/Tab
Hi Zoho WorkDrive Team, Hope you are doing great. We encountered a limitation when recording a selected window or browser tab: Certain UI elements, such as dropdown lists, hover menus, and overlays, are not captured unless we record the entire screen.
Add Camera Background Blur During Recording
Hi Zoho WorkDrive Team, Hope everything is well. We would like to request an enhancement to the video recording feature in Zoho WorkDrive. Currently, the camera preview displayed during a recording does not support background blur. This is an essential
WorkDrive Desktop Sync Is Being Deprecated: Move to WorkDrive TrueSync for a Smarter Experience
Hi everyone, We are excited to share a better, smarter way to access and manage your files directly from your computer! We’re transitioning from our legacy Desktop Sync app to WorkDrive TrueSync, designed to give you faster performance,greater flexibility,
Support Uploading YouTube Videos Longer Than 60 Minutes
Hi Zoho Social Team, How are you? We would like to request support for uploading YouTube videos longer than 60 minutes directly through Zoho Social. Your support team informed us that Zoho Social currently cannot upload videos over 60 minutes due to “API
Caso de Éxito: ACKstorm transforma la gestión de personas con Zoho People
"Con Zoho People hemos centralizado la gestión de personas y facilitado la autonomía de la plantilla." Equipo de ACKstorm ACKstorm es una empresa especializada en consultoría y servicios cloud que trabaja con el ecosistema de Zoho para optimizar sus procesos
Zoho Books Sandbox environment
Hello. Is there a free sandbox environment for the developers using Zoho Books API? I am working on the Zoho Books add-on and currently not ready to buy a premium service - maybe later when my add-on will start to bring money. Right now I just need a
Action required: Authenticate your sender domain in Zoho Marketing Automation before December 14, 2026
Starting December 14, 2026, Zoho Marketing Automation will enforce a daily sending cap for unauthenticated custom sender domains. If you're sending email campaigns from your own domain but haven't authenticated it yet, you'll only be able to send up to
Ask the Expert: Unlock the Power of AI and Zia Agents in Zoho CRM
Are you using Zoho CRM to manage your sales processes and customer relationships, and wondering how AI can help you work smarter, automate more, and take your CRM capabilities to the next level? We have great news: the “Ask the Expert” session is coming
What's new in Zoho Desk 2026 - A decade of ideas brought to life
Hello everyone, 2026 marks a special milestone for us as we celebrate 10 years of Zoho Desk. A decade into business, there is always something new to keep up with, new expectations to meet, and new ways to make customer support better. Zoho Desk continues
Manual categorisation of bank transactions
Good Day I am hoping someone here can assist me. I have a lot of catching up to do with some bank transactions. I imported all my bank statements manually. Where possible i created a rule to have the transactions auto categorised. However there are some
Idea: Upload your own letterhead and design PDF templates freely (like Lexware Office and sevDesk)
Your own letterhead on every invoice and quote, uploaded in two clicks, no HTML, no public image links. Tools like Lexware Office (formerly lexoffice) and sevDesk already offer this. Zoho Books is more powerful in almost every other way, so let's close
Sorting of invoices keeps changing
Hi there, I log into Zoho invoice around 2-3 times a week. Usually I sort my invoice list by "Date created". Every now and again when I log in, this sorting criteria has changed. It's not clear to what criteria it is changing and how/why, but I find it a little annoying not seeing the latest invoices at the top. Can you please look into this and make sure the sorting function is stored in a cookie or on the server? Thanks, Kai
Feature Request: Add Sort by Cell Color and Text Color functionality
Hello Zoho Sheet Development Team, I am writing to suggest a feature enhancement for Zoho Sheet. Currently, the platform supports "Filter by Color," which is incredibly useful. However, there is no native option to "Sort by Color" (by cell fill or text
Multi-Day Installations
We schedule technicians on multi-day installations. A single appointment from Monday 8 AM through Friday 5 PM counts as 105 working hours, causing false overbooking. We need one appointment spanning five days but only 40 hours counted toward technician
Rebrand your CRM with the all-new custom domain mapping setup
UPDATES TO THIS FEATURE! 19th Jan, 2024 — Custom domain mapping has been made available for portal users in Zoho One and CRM Plus. 23rd June, 2023 — Custom domain mapping has been made available for all users, in all DCs. Hello everyone! We are elated
How to manage additional required address information for Customers and Vendors.
Has anybody figured out a way to incorporate relevant delivery information in the limited address fields for customers and vendors? For example, most carriers have an additional 'delivery instructions' field to add important information like delivery
Action required: Authenticate your sender domain before December 14, 2026
Starting December 14, 2026, Zoho Campaigns will enforce a daily sending cap for unauthenticated custom sender domains. If you're sending email campaigns from your own domain but haven't authenticated it yet, you'll only be able to send up to 5,000 emails
Change default "Sort by"
Is there a way to change the default "sort by" when searching across modules?" in Zoho CRM? Currently the default sort method is "Modified time" but i would like to utilize the second option of "relevance" as the sort by default and not have to change
Enhanced access controls and smoother authentication for organization emails
Available to customers in all DCs. Hello everyone, We've improved how organization emails work in Zoho CRM, which are used when multiple users need to send emails from a common address, like sales@company.com or support@company.com. Admins can set up
New Search Function
Hey Team, The search function updated in our CRM about a week ago, so I assume it was an automated update across Zoho. It no longer displays leads/deals etc in Chronological order so that the most recently created or updated is the first to display which
Error AS101 when adding new email alias
Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.
Transaction rules for "Owner's Contribution" ?
I have a bank account where a lot of the deposits are "Owner's Contributions" (i.e., the business owner investing money in the company). Is it possible to create a Transaction Rule to automatically recognize these? They all have the same verbiage from
Print a price list or price book
Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (more
The Social Wall: October 2026
Hello everyone This month, we're making it easier to organize your monitoring workspace with Monitor Groups in Zoho Social. Organize your monitor columns into groups You can now organize your monitor columns into custom groups based on your preferences.
Field of Lookup - 5 Field Association Limit.
This query relates to the post at: https://help.zoho.com/portal/en/community/topic/introducing-the-field-of-lookup-in-crm-public-early-access-2023 My simple (and common) scenario: I select an account / customer lookup and want their address pulled into
Feature Request - Electronic submission of tax returns in Canada
Allow the user to submit Canada Revenue Agency GST/HST returns with NETFILE. Provide the same functionality for provincial revenue agencies for PST/RST remittances. Today Zoho Books only provides the math required to calculate each line, requiring the
Next Page