Tip of the Week - Conditional Formatting Chart

Tip of the Week - Conditional Formatting Chart

Conditional formatting allows you to highlight your data series based on a pattern or a trend in your data. This makes it easy for you to identify when your data reaches certain values or when it deviates from the trend. 


Zoho Analytics allows you to format chart data points with specific color based on a condition. In this week's tip, we'll see how to apply conditional formatting over your chart. 



Let's see how to format the Profit across months by the profit range.


  1. Open the chart in Edit Design mode.



  2. Add the Profit column in the Color shelf. 



  3. Zoho Analytics will intelligently identify the pattern in your data to categorize your data into various buckets and apply color over them. You can change this to your own specific conditions using the Settings page.
  4. Click the Setting icon to open the Settings page and navigate to the Legend tab. 



  5. In the Color section, click Custom .
  6. Specify the range to format in the Min and the Max field. 
  7. In the Label field, specify required name for your legends. 



  8. Click the Color tile to change color. 



  9. Click Apply . The chart will be formatted based on the conditions you have specified. 


Now we have applied formatting based on a simple condition. Zoho Analytics allows you to format the chart based on advanced conditions using the Formulas . 


Let's see how to format the same chart by the Profit Percentage based on your sales. 


  1. Create a formula to calculate the Profit Percentage using the following format. 

     

    sum( "Sales"."Profit" )/sum( "Sales"."Sales" )


  2. Now categorize the profit into groups based on profit percentage. The following formula groups profit into below four groups.
    • below 50%
    • 50% - 60%
    • 60% - 70%
    • Above 70%

      if( "Sales"."Profit Percentage" < 0.5,1 , if( "Sales"."Profit Percentage" < 0.6,2, if( "Sales"."Profit Percentage" < 0.7,3,4 )))                         


  3. Now add the Profit Category formula in the Color shelf of chart designer. 



  4. Open chart settings and customize the Legend. 
  5. Your final chart is ready.

We believe this will be useful for you. Stay tuned for more nifty tips.

    • Sticky Posts

    • What's New in Zoho Analytics - October 2025

      Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme

    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded

    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.

    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security

    • Zoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience

      Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that you

    • Recent Topics

    • UNEXPECTED RESPONSE CODE: 400"

      Getting this on all new flows created with a Zoho Campaigns connection

    • Suburb Categorisation/value

      Hi All, I have a list of suburbs that my company services, they are categorised by value to the business using a letter grade (A,B,C,D). When a lead is created I want the workflow to check the project suburb and then assign the related grade to a new

    • Launching AI-backed product recommendations for ecommerce stores

      As Zoho Campaigns steps into its 11th year, we're taking our first step towards artificial intelligence as part of our ecommerce module. Your emails—be they regular or automated— are equipped to carry unique and targeted product recommendations based

    • Add Custom Text Fields as a component in Dashboards

      Hi Team Idea: Adding custom text fields as components in dashboards. This will allow those of us creating the dashboards to better segment the dashboard into sections allowing a better front user experience where we are showing different categories of

    • FSM API ERROR Code "OAUTH_SCOPE_MISMATCH"

      I am trying to create a contact via the ZOHO FSM API https://fsm.zoho.com/fsm/v1/Contacts I have followed the instructions of the API documentation to Authenticate and Create a contact but I cant figure out what I am doing wrong. Bellow are the steps

    • TaskList at Bottom from API

      When I create a taskList from API the TaskList is always At the Top, I need it to be at the bottom. How can I achieve that?

    • Linkthread domain names - none available

      Hi I am trying to add our domain names but they do not seem to be available but I am pretty sure they would not be taken as yet. Does Linkthread recognise .com.au or .org.au domains?

    • Setting default values in CardScanner app

      We use the Zoho Cardscanner app. Is it possible to set default values. For instance for "Lead source" to set the default value to "Exhibition". Now we have to manually select that for every card we scan.

    • Custom Fields like Discount

      Hi, Is it possible to make a custom field that acts like the discount field in quotes? I would like the option to have the field pop up exactly like Discount but instead of subtracting money it adds money (shipping cost in this case). I would like it

    • "Unable To Join Group Call"

      When trying to join a group call within Trident on macOS, I get a popup that says "Unable To Join Group Call". No other explanation is given. Anyone invited to a call should be able to join at all times, even if the organizer has not joined the call.

    • Effective project development with integration of Zoho Desk and MS Azure

      Dear partners, We are happy to announce that you can now integrate your Zoho Desk account with Microsoft Azure DevOps. This integration provides an effective way to: Manage feature requests Collaborate with teams Streamline development processes Dispatch

    • No-reply email account without taking up a user license?

      I just upgraded our zoho mail account to the paid tier and purchases 7 licenses. When setting up our new users I can't add the 7th one because I have a no-reply email account created to be able to send automated emails from our server. How do I go about having an account like that without taking up a user slot? All it needs is outgoing mail, no receiving or anything else.

    • ¿Por qué no te puedes perder los Workshops de Zoholics 2025?

      Cada año, Zoholics reúne a cientos de profesionales, emprendedores y entusiastas de la tecnología para compartir ideas, aprender unos de otros y descubrir todo lo que el ecosistema de Zoho puede ofrecer. Pero si hay una parte del evento que realmente

    • Fetch Project's Task by Name

      Why is there no way to fetch a projects task by name? https://www.zoho.com/projects/help/rest-api/tasks-api.html#alink1 I have looked in the documentation but didn't find a way to fetch tasks by Task Name Am I missing something?

    • Error when adding an existing user to Zoho Project

      In the Zoho Projects Flow if an existing user is added to the project it results in an error There should be a way to automatically skip adding the user if it already exist in the Project instead of halting the whole Flow

    • Cannot Trigger Purchase Receive Flow from Both Books and Inventory

      I have created a flow for Zoho Inventory Purchase Receive Normally the purchase receive is created in Inventory, but sometimes the Purchase Receives gets created in the Books the the flow doesn't trigger Is there a way to trigger the flow whether the

    • New VAT Rate for South Africa

      Hi, When will the new VAT Rate be implemented as it is from 1 May 2025, and how will updates etc happen. Will there be a global update function. Thanks

    • South Africa VAT increase from 1 May 2025

      Hi Will Zoho Books automatically update the VAT settings from 15% to 15.5% or must it be done manually? The VAT rate is increasing to 15.5% on 1 May 2025, and supposedly to 16% in 2026. Regards Uwe

    • Power of Automation :: SLA for Tasks

      Hello Everyone, In this 'Power of Automation' series, we are focusing on the feature "Time-Based Workflow Rules for Tasks." Workflow rules help project managers organize tasks in a project by setting criteria and actions that meet the project requirements.

    • Restrict Payment Methods

      Allow us to restrict certain payment methods specific for each customer.

    • Widgets in People 5

      I'm trying to add a button widget in one of our test sites, created using the Zet-CLI Tool. When I host the Widget externally it runs fine, making a call to a UK Government API and downloading some json and displaying a table of data. If I try to host

    • Convert a message on Cliq into a task on Zoho Connect

      Message actions in Cliq are a great way to transform messages in a conversation into actionable work items. In this post, we'll see how to build a custom message action that'll let you add a message as a task to board on Zoho Connect. If you haven't created

    • Zoho mail not working after Domain expiration and renewal

      Need help getting email working after an accidental domain expiration. Domain has since been renewed.

    • eway Bill - Import (Good / Material)

      As we Importer of goods , for That first we Generate PO then , Payment, then after We create Bill of Entry  After Bill of Entry Anywhere (99%) cases material that arrived to port that comes to warehouse / factory for that Eway bill , we have to create

    • In zoho creator I have Category form it has category name field Once Enter category name , category code want to Auo create on submit of the form

      In zoho creator I have Category form it has category name field Once Enter category name , category code want to Auo create on submit of the form Code Create Format first letter of product with number of product on this category Example: I have one use

    • Let's Talk Recruit: Meet Zia, your all-in-one AI assistant

      Welcome back to our Let's Talk Recruit series! Today, we are going to meet Zia, your all-in-one AI assistant. Let's delve into Zia's capabilities and explore how it takes tedious, time-consuming tasks off your plate. What is Zia? Zia is your AI companion

    • Zoho ONE Inventory and Zoho FSM

      Zoho ONE Inventory sees a warehouse just as a warehouse. You have to be a ZOHO ONE usher for example to use a warehouse like counting stock while you have to buy a warehouse as an Add one separately from ZOHO ONE Inventory to use it for ZOHO FSM In ZOHO

    • Export all of our manuals from Zoho Learn in one go

      Hi, I know there's a way to export manuals in Zoho Learn, but I want to export everything in one go so it won't take so long. I can't see a way to do this, can I get some assistance or is this a feature in the pipeline? Thanks, Hannah

    • How to Mass Delete 26K leads ?

      Hi, can anyone tell me how I can mass delete 26K leads please? Thanks Colin

    • 【Zoho CRM】サブフォームのアップデート

      ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中からサブフォームのアップデートをご紹介します。 サブフォームは、複数の行項目をまとめて管理できる副次的なフォーム/表です。例えば、営業チームがCRMのサブフォームを使って顧客の注文を管理する場合、商品名・価格・納期などの情報をまとめて入力できます。 ただし、このサブフォームのリスト自体が長くなると、スクロールが必要になり、画面上で確認する際に情報を把握しづらくなることがあります。 この課題を解決するため、サブフォームの列で「複数列のピン留め」と「項目列の幅の調整」の2つの新オプションの使用が可能になりました。

    • Is there a way to Prefill A Subform in Zoho Forms?

      By The Grace Of G-d. Hi, Is there any way to prefill a subform? Using URL Parameters or something else?

    • Updating Auto Numbers

      I'm removing a suffix from my auto number that's related to my customer record. I would like it removed from all existing customer records but I don't want to change the number before the suffix. If I tell it to update existing records, will it overwrite

    • How to add categories?

      How to add categories? I don't know if it is possible to create categories of the services, for example if the reported issue is a printer problem, hardware, email account, etc. I have only seen that the ticket is chosen if it is a complaint, question,

    • Zoho CRM in Microsoft Power Automate Custom Data Connector

      Hello, I have set up a custom data connector in Microsoft Power Automate. It is a connector to retrieve Zoho CRM data. I am pretty certain that I have entered the OAuth 2.0 authentication information correctly. However when I test the Get request https://zohoapis.com/crm/v2/leads.

    • Client Script: new value not set after calling setValue() - what's wrong?

      I'm new to Javascript and Zoho Client Script, though I have experience developing applications in C and Java. I have been trying to figure out why my code doesn't work and would appreciate help from the community to point out what's wrong. For my current

    • Sorry! we encountered some problems while sending your campaign. It will be sent automatically once we are ready. We apologize for the delay caused.

      Hello. Lately we are having problems with some campaigns, which show us this error message. Sorry! we encountered some problems while sending your campaign. It will be sent automatically once we are ready. We apologize for the delay caused. We can't find

    • ZOHO not recognizing mx records

      My domain hosting lapsed, and upon reactivating I had to recreate all my DNS records. ZOHO is not recognizing my MX records, but IS recognizing my SPF, DMARC, etc. Mail is being delivered to ZOHO just fine, but when I attempt to send I get a "relaying

    • mail rejected because of sender's SPF record issue

      We recently started hearing from customers that email is bouncing with the error: 550 5.7.23 Sender's SPF Policy Failure We cannot reject email because sender's DNS record is wrong. We need to accept mail in most cases. How do we fix this (because clearly

    • No fue posible enviar el mensaje;Motivo:554 5.1.8 Email Outgoing Blocked.

      Hola! quiero enviar un correo electronico desde mi casilla de correo " tallerenproceso@zoho.com" y no me permite, porque dice: " No fue posible enviar el mensaje;Motivo:554 5.1.8 Email Outgoing Blocked." lei que otros usuarios le daban respuesta de almacenamiento,

    • BLOQUEO DE POP-ENTRANTE

      Solicito con urgencia su apoyo, la cuenta dnanez@mirandacorredores.pe tiene problemas con el correo entrante. Tiene habilitado la opción POP en ZOHO y maneja sus correos con la herramienta Outlook, sin embargo no puede recibir ningún correo ya que aparece

    • Next Page