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

    • Multilingual website feature

      Would be a great feature to have. I saw that this feature was available for backstage. I think it could be done for zoho sites too.

    • Feature Suggestion for Zoho Social: Auto-reply to Comments or Keywords

      Hi Zoho team, I'd like to suggest a very specific feature that would be extremely helpful for customer engagement: the ability to automatically send a reply to comments on posts — either all comments or those containing specific keywords. For example,

    • How Can i Add Email campaign for my UAEVisaOnline.center website

      Hello Team, i want to create email campaign for our website https://www.uaevisaonline.center but can't able to add. Its showing error like please try after some time. Can you please help and solve the issue. Thanks!

    • The domain Etihaduaevisa.com which you have entered belongs to a different deployment/region

      Hi Team, I am trying to set up a business email account to Zoho for www.etihaduaevisa.com but it doesn't allow me There is a message that pops out The domain which you have entered belongs to a different deployment/region Kindly assist me with this. Thank

    • Outlook not recognising Zoho Inbound server

      I have been receiving my ZOHO emails using MS Outllok on my iPhone and PC, but since Friday 2nd May, incoming emails are not arriving via Outlook and I get the error message saying the server is 'not responding'. Have ZOHO changed the settings for the

    • Zoho Sign / CRM integration - stop unsigned documents being attached

      I'm using the the CRM/Sign integration to send documents for signature from Zoho CRM. I noticed that an unsigned copy of the document is added as an attachment in the CRM. Is there a way to stop this? I only want signed documents to be attached. The unsigned

    • Resend invite

      Hi, How do I resend an invitation to someone who didn't get the invite the first time around? I tried going to Setup-->User (like it says in the Help) but there was no option to resend. It doesn't display any users who has not accepted the invitation.

    • Asking for implementation roadmap or step-by-step guidelines

      Hello everyone, I'm a freelancer who's been hired to implement Zoho CRM for a client, and I want to make sure I approach this correctly. Could someone kindly share a comprehensive implementation roadmap or step-by-step guide that covers all the essential

    • Asking for implementation roadmap or step-by-step guidelines

      Hello everyone, I'm a freelancer who's been hired to implement Zoho CRM for a client, and I want to make sure I approach this correctly. Could someone kindly share a comprehensive implementation roadmap or step-by-step guide that covers all the essential

    • Approval Workflow for Purchase Orders Abrir

      The requirement is , that all purchase orders greater than or equal to 5000 go through an approval process from certain people, but within books I only see that the approvers can be by levels or any approver but we cannot enter a rule like these. Can

    • Multiple subforms from same existing form

      Hello, In an Order form, I have a subform for Line items. But my items have 5 distinct product categories. To make it pleasant and easy to use, I want to repeat the subform 5 times in the same parent form, to separate my 5 categories of product. But I

    • Announcement: Zoho DataPrep 1.0 will be deprecated on January 31, 2026

      We'd like to inform you that the Zoho DataPrep 1.0 version will be officially deprecated as of January 31, 2026. This aligns with our efforts to streamline and improve your overall experience with Zoho DataPrep 2.0 which was released in Sep 2024 . To

    • Discussions from Ask the Experts 19 : Inside Zoho Desk Spring Release 2025

      Hello Everyone, We appreciate the engaging discussions during the Ask the Experts 19 session on the Spring Release. It was a pleasure connecting with you. Our team is actively working towards your requests to deliver an improved experience. In this post,

    • Optimisez la gestion des bots et la conformité à Apple MPP

      Filtrage des bots : une nécessité pour des données marketing fiables Les indicateurs de performance sont au cœur de toute stratégie marketing. Cependant, l’augmentation du trafic généré par des bots ainsi que l’adoption croissante de fonctionnalités comme

    • One time batch workflow to repair omission of data

      Hi, I created a parent form (Product) and another form (Prices) that is used as subform in the parent form. In the parent form I have a field Category that must appear in the subform, but I forgot to create the field at first in the subform and now I

    • Advance Your Churn Predictions with Zia's Usage Data Feature: Event Mapping

      Greetings all, This is an important and exciting update about feeding usage data into Zoho CRM. To expand the scope of how usage data can be used by Zia, we are introducing a new section called Usage Data under Zia. Users can now easily import, edit,

    • Web-To-Quote form would be awesome

      It would be awesome to be able to embed a quote form on a website and have that filter in to Zoho CRM. Account Number to match the Account in Zoho Email address could match the Contact. Product Code could be required to match the product. Not sure about quantity? I am sure this all could probably be done via the API and maybe some middleman interaction with Creator, but it would be nice if it was as easy as the Web-to-Case form. Something like this could lead to further integration with CMS and Shops

    • Published Sheet - Share option to show "Save copy to WorkDrive"

      Hi Sheets Team, I'm currently working on a Zoho Sheet which I want to share with other Zoho users outside of my organisation. Normally I would do this with Google Sheets but I'm trying to make better use of my Zoho tools. When I share a Google Sheet publicly

    • Bills vs. Expenses

      Hi eveyone, Can somebody explain me a little bit better of how can I use Bills and Expenses in my business? I don’t understand their differences to be honest.

    • Integration to LinkedIn Recruiter

      We'd like you to support Recruiter System Connect to sync our LinkedIn Recruiter candidates to the Zoho Recruit ATS. How can we do this?

    • List View just got a makeover!

      Hello everyone, The new list view is being rolled out in phases and will be available to all our users by the end of January 2021. We are excited to announce that the list view in modules is set to get a new look. The new list view is sleek, contextual,

    • Add Video block needs improvement

      I regularly send out links to videos in my campaigns and I find that built in video block is never good enough to use in my campaigns, so I have to make a thumbnail in Canva and upload it or screenshot the actual video on YouTube. The concept of the video

    • Profile cannot add tasks, calls or meetings

      Good morning, I have a Profile of users that's called "Standard2" and their module permissions are set as follows: Despite this, one of my users on the Standard2 profile gets this when they try to add a call: Any idea how to fix this? If i bump them up

    • Zoho Developer Community Monthly Digest – April 2025

      Hello everyone, Welcome to this month’s Zoho Developer Community Digest! We’ve lined up an exciting series of technical sessions, product deep-dives, and community conversations to keep you informed and inspired. Don’t forget to check out our resource

    • Dataprep est-ce que zoho est sérieux ??

      Nous venons encore de passer plus de 2 heures avec le support zoho qui est incapable de résoudre le problème rencontré dans la mise en place d'un pipeline de données entre le C>>RM et DataPrep Celà fait 5 mois que nous essayons de faire fonctionner le

    • STOCK COUNT - How is this even possible

      Dear Zoho One, We have a lot of products from Zoho but I really don't understand this. We mainly use ZOHO FSM with ZOHO INVENTORY because we are in service and maintenance for electric charging stations for cars All employees of Zoho FSM have their own

    • Changing sequence of buttons

      How can I change the sequence of these buttons? I want the 'Versturen referral campagne' to be displayed as the default button

    • Unapproved Articles for Review?

      What is this feature and how do I use it? I'm not seeing any option to mark articles as unapproved and needing review.

    • Trying to fetch related list data from deals module

      I need to fetch stage history data which comes in related list in deals module using coql. How can I achieve that? { "select_query": "SELECT Technical_Survey_Date as system_order_confirmation_date, Stage,Created_By, Latest_Quote_Creation_Date,Originating_Source,

    • Stage-Probability Mapping

      How do I answer this question in analytics? What is the Closed-Won percentage of all Deals that reach a given stage? Another way: Of all Deals that reach a given stage (eg. Artwork/Price Quote), what percentage of them become Closed-Won? I want to populate

    • Follow-up Sequences

      For following up with leads based on open/click status.

    • How do I change the sort order of items in the User Filter?

      I have a chart for which I have set a custom sort order for a field. I noticed that in the user filter for this field, the order is shown as alphabetical. It does not reflect the custom sorting that I configured. I even tried selecting the checkbox "Make

    • Automate Zoho Projects Task Data Export and Email Delivery (for Non-Users)

      In many real-world scenarios, we need to share Zoho Projects task updates with clients or team members who don’t use Zoho or don’t have access to the platform. Since there’s no built-in way to export and email tasks directly within Zoho Projects, I put

    • Bulk Add notes

      I think that it's an absolute need and basic feature to add. I know we can import notes from an xls spreasheet, but that's not what I'm talking about. We should be able the same way that we can bulk send email, bulk add activities, we should be able to

    • How to use CRM custom button and client script?

      Here's what I need. I know how to handle each step in isolation. I do not understand how to intercept a Button interaction, pass it to the client-script for the user prompt, and remainder of the processing. User Clicks Button on Details Page Client-Side

    • Match one bank transaction to multiple customer with TDS dedcuction

      Hi team, Just wanted to know. How can i match one bank entry to multiple customer invoices with tds.

    • Zoho Product Sync between Books and CRM is a mess

      The syncing of products between Zoho Books and CRM is completely broken. Why is ZOHO CRM the center of all products? Surely it should be Books or Inventory that is the central focal point of all things to do with a business backend (i.e. not marketing

    • How can i resend a campaign to only one of the recipients on the original campaign

      How can i resend a campaign to only one of the recipients on the original campaign ? Sincererly, Mike

    • Zoho Campaign low open rate

      I have been using Zoho One, Zoho CRM and Zoho Campaign to make my web application, but since I started using zoho campaign to send emails, it has low open rate (actually zero for the latest campaign for 2 days) For people who have more experience or know

    • More Workflow Triggers

      We utilize a lot of workflows in our organization. Recently we've identified two use cases where we would like a workflow to run a function. Upon further checking, the workflow trigger wasn't available, or the only option was to run the workflow more

    • Next Page