Spotlight Series #21: Link data to charts and tables in three easy ways

Spotlight Series #21: Link data to charts and tables in three easy ways



Your audience won't remember your content if you simply say, "Our growth rate has increased." Instead, try, "Our growth rate has increased from 11% to 20% in just 6 months." Adding data is the best way to make your presentation more memorable. Visualizing it is even better, as it helps your audience understand your point at a glance.

In Spotlight Series #18, we examined different types of charts and their uses. In this month's spotlight series post, we'll discuss how to add data to a chart or table in different ways.

Ways to add data to charts and tables

Get started by creating a chart: Click on Data Art and choose an appropriate chart or table style, and click Insert to add it to your slide. Here is how you can add data to your chart or a table.

Manually 

Once you insert a chart, you will be able to enter the data. You can also modify it by clicking the Edit Data button in the right bottom corner.



However, this will not be efficient if you are handling a large amount of data or working with variables that change frequently. In such cases, doing it manually can also lead to errors.

Using data fields

Let's assume you are preparing the sales performance report for your company across regions for every quarter. Few data like the team's contact details, sales revenue numbers, and client details will keep changing across different regions.

Instead of creating new presentations for every region, you can store the values as data fields and update them across slides in a single click. This is more efficient because you don't have to spend time designing the slides and rewriting content every time.

Here is a detailed guide on how you can add a data field to your presentation.

To use the existing data field in your data art, click on the Data Fields option in the bottom left corner (under Link Data) and select the required field.




Linking data from Zoho Sheets

Companies are storing a significant amount of sales and marketing data in spreadsheets. Most of this can be used in various business presentations.

You no longer have to switch between tabs to import or add data to your slides. Instead, you can fetch data stored in Zoho Sheets directly from the Show interface.

Click the Insert Spreadsheet option next to the Data Field option. A pop-up box appears which will show you the list of files stored in your WorkDrive. Choose the file with the data and click Pick.

Now you'll be able to see a preview of the spreadsheet. Select the cell range that contains the required data and press the Update button. Choose the appropriate chart or table type and click Insert. Your data art will now be added to your slide.

Also, if there is any change in the values in the spreadsheet, the changes will automatically be updated in your presentation by clicking on the Sync button.

Detach mapping from a chart or table

You can remove the data you have linked to a chart or a table by detaching the field. You'll be able to make this change to a single slide as well as the entire presentation.

If you want to use the data stored in the same spreadsheet, you can also edit the data field without deleting it.
Check out the guide to detaching a data field for more information.
 


      • Recent Topics

      • KPI Widget dashboard select periods

        I have a problem with selecting periods as a user filter. In the beste scenario I would like to have to have a period filter like Google Analytics has of Datastudio (see attachment). In the KPI widget I "Group by "inquiry_date" on week&Year". It selects

      • Need a way to secure Prefill URLs in Zoho Forms (hide or encrypt prefilled values)

        Hi everyone, I often use Zoho Forms with prefilled URLs to simplify the user experience — for example: https://forms.zohopublic.com/.../form?Name=David&Amount=300 However, the problem is that all prefilled values are visible and editable in the link.

      • Can’t send emails from Zoho CRM after adding a new user — verification codes not received

        Hi everyone, We recently added a new user to our Zoho CRM account and purchased an additional license. Since then, we haven’t been able to send any emails from Zoho CRM. Our Zoho Mail accounts are working perfectly, we can send and receive emails directly

      • CRM for email in Outlook: how to ignore addresses?

        We’re using the "Zoho CRM for email" add-in for Outlook. When opening an email, the add-in displays all email addresses from the message and allows me to add them to the CRM or shows if they’re already contacts. However, sometimes people listed in To

      • Scheduling Calls in CommandCenter / Blueprints

        I would love it if you could add a function to schedule a call in the lead's record for a future date. I know you can add a Task by going to Instant Actions > Task and completing the form: These tasks go into the lead's record under Open Actions. But

      • Workflow Creation with Zia gets stuck

        It gets stuck here:

      • Quickly send emails and sync conversations with custom email addresses in CRM

        Editions: All editions DCs: All DCs Release plan: This enhancement has been released for customers in all DCs except IN and US. We will be enabling it for IN and US DC customers soon. [Update on 22 May 2024] This enhancement has been released for all

      • Zoho製品と生成AIツールの活用について

        いつもありがとうございます。 弊社では、Zoho Oneを契約し、CRMを軸として、見込み客の管理から商談、その後の受注や請求の管理、サポート業務（Desk）、業務データのレポーティング（Analytics）などを行っております。 Zohoサービス自体には、Ziaというツールが搭載されているかと存じますが、それ以外の外部の生成AIツールと連携した活用などもできるのでしょうか？具体的には、CopilotなどがZohoに登録されているデータや情報を見て、対話型で必要なデータを提示してくれたり、商談や蓄積されたメモなどを分析してユーザが知見を得られるような活用ができないか、と考えております。

      • Work with Contacts who use multiple Emails / Manage obsolete Email addresses without loosing Emails in Context

        Hello List Work with Contacts who use multiple Emails Only after 1 week in using Zoho CRM productively we have contacts which randomly use 2 different email addresses. From the concept I've understood that Zoho CRM offers two email fields which are recognized

      • New Field in CRM Product Module Not Visible in Zoho Creator for Mapping

        I created a new single-line field in the Products module in Zoho CRM. Zoho CRM and Zoho Creator are integrated, but the newly created field in CRM is not visible in Zoho Creator when I try to map fields.

      • Send WhatsApp voice messages from Bigin

        Greetings, I hope all of you are doing well. We're happy to announce this enhancement we've made to Bigin. Bigin's WhatsApp integration now supports audio messages, so you can record and send voice messages. This makes it easier to handle customer questions

      • Microsoft Teams now available as an online meeting provider

        Hello everyone, We're pleased to announce that Zoho CRM now supports Microsoft Teams as an online meeting provider—alongside the other providers already available. Admins can enable Microsoft Teams directly from the Preferences tab under the Meetings

      • I want to subscribe 1 professional user but the email only 250 per day?

        When I subscribe 1 professional user, I am only able to send 250 email per day? So less? Or is it typo, 2500 rather than 250? Any sale agent or friends can clear my doubt? Thank You

      • How to add a % Growth column for year-over-year comparison (2024 vs 2025)

        Hello, I am trying to build a monthly revenue comparison between 2024 and 2025 in Zoho CRM Analytics. My current setup is: Module: Deals (Affaires) Filter: Stage = Closed Won Date field: Closing Date Grouping: By Month Metrics: Sum of Amount for 2024,

      • How do you map a user picklist field to another user picklist field.

        In Zoho Projects, I'm trying to map a custom field (user picklist) in Task Details to a field (user picklist) in the Project Details. How do you get the two to map to each other? This is what I currently have that works for my other fields but doesn't

      • Explore Competitive 3D Scanner Prices at Protomont Technologies

        The genesis of Protomont Technologies emerged from the collaborative efforts of the founders in 2019, both the founders shoulder an enormous experience in the world of 3D Printing. Protomont Technology aims to craft your vision with creativity, empowering

      • New and improved API resources for Zoho Sign Developers

        Hello, Developers community! We know that for you, an API's real value depends on how quickly, easily, and reliably you can integrate the it with your application. That's why we're excited to talk about the recent improvements to our developer resources,

      • stock

        bom/bse : stock details or price =STOCK(C14;"price") not showing issue is #N/A! kindly resolve this problem

      • Project Approval Process Workflow

        Issue: When a new Project is created, there is lack of process/workflow that provides their manager a process to approve or review. Suggestion/Idea: Similar to “Workflow”, we need “Workflow” ability at Project level, where based on the criteria of the

      • Marketing Tip #5: Improve store speed with optimized images

        Slow-loading websites can turn visitors away. One of the biggest culprits? Large, uncompressed images. By optimizing your images, your store loads faster and creates a smoother shopping experience leading to higher sales. It also indirectly improves SEO.

      • Why can I not choose Unearned Revenue as an account on items?

        Hello, I do not understand why we don't have the ability to code an item to unearned revenue. It is not an uncommon situation to have in business. I understand that there is the Retainer invoice as an option, however that doesn't really work for us. Our

      • Form Submission Emails

        Is there a current delay with submission emails being sent? We've had 10-20 forms completed today but only a handful of emails.

      • Rules not working properly

        I created a rule to display certain fields on certain states. But it seems to be not working. It hides the fields even when I selected California, (which is a state that should show the fields when selected)

      • Notebook font size issue

        If I copy something from somewhere and paste it in my notebook, the font size becomes smaller.

      • Sign in process is beyond stupid. I'd rather plug my phone into USB and copy files than sign in to this POS.

        792 clicks and fields to fill in just to get into a 3rd rate app is too stupid for me.

      • Ampersand in URL parameter // EncodeURL does not work

        Hi Zoho, I have a url link with a parameter. The parameter is including ampersand in some cases (Can be "H&M" or "P&I") When trying to use %26 instead of "&"  (the result I get using EncodeURL()) I get H%26M instead of H&M in the parameter field. How can I solve this? Thanks! Ravid

      • how can we create in zoho crm a new contact when the looup does not find a similar existing one

        In forms/integrations/zoho crm / ne w record tab, contact name is to be mapped with my form contact name. When I go in biew edit/lookup configuration, I don t get the options (help dedicated page simply repeat the same info you get in the app) and does

      • Directory Websites

        Directories are a good website category to gain search engine traffic. Directories for a professional service category as an example can help their members in search results over their individual website. It would be nice to have a directory template

      • Manage Task on Mobile

        How do we manage our task on mobile devices? It seems that there should be a standalone mobile app to handle the new task features. The new features released in regards to Task management are great by the way! Now we need to bring that all together in

      • Set Default Payment Method & Default account

        Hi, I would like to know how to set the default payment method and default bank account when recording payments in zoho books. At present we have to change these fields everytime we record a payment, which leads to potential error and as we have a very

      • Customer Portal on Zoho Desk

        Hi, I'd like to know more about the items below I found when setting up the Customer Portal on Zoho Desk. Could someone help me explaining these in details? Especially the 2nd and 3rd point. Thanking you in advance! Permissions Customers can sign up for Customer Portal Customers can view tickets of their organization (contacts) Customers must register to access Customer Portal Display Community in Customer Self Service portal

      • Slow Performance on desk.zoho.com. 11/3/2025

        I’m not seeing any active service alerts for desk.zoho.com, but everyone on our account is currently experiencing very slow load times when opening or navigating tickets. We’ve already tried the standard troubleshooting steps — clearing cache and cookies,

      • Computer Showing Offline in Unattended Access

        I have a computer that was connected to the internet but showing offline in Assist. I tried uninstalling the program and deleting it from Zoho Assist the reinstalling and it still does not show up. I have been a user for several months and am not pleased with the lack of connectivity with Assist. If this continues I will have to find another product. The computer I reinstalled it on is not even showing up in Assist now. The name is NYRVLI-PC. Thanks

      • Closing Accounting Periods - Invoice/Posting dates

        Hi, I have seen in another thread but I'm unsure on how the 'transaction locking' works with regards to new and old transactions. When producing monthly accounts if I close December 24 accounts on 8th Jan 25 will transaction locking prevent me from posting

      • Zoho CRM Portal Error

        Hi, We’re experiencing an issue with the Zoho CRM Portal. When we try to access it, we receive an HTTPS connection error: net::ERR_CERT_COMMON_NAME_INVALID. If we proceed past that, we then get a 400 Bad Request error. Could you please help us resolve

      • Can we do Image swatches for color variants?

        We want to do something like the attached screenshot on our new zoho store. We need image swatches instead of normal text selection. We want to user to select an image as color option. Is this doable? I don't see any option on zoho backend. Please h

      • Integrating Zoho CRM EmbeddedApp SDK with Next.js — Initialization and Data Fetching Issues

        You can get an idea from my code I have given in end: First, I worked on a React project and tried the same thing — it worked. My goal was to import the Zoho script and then load contacts using the Zoho Widget SDK, which was successful in React. Now,

      • Script Editor not an option

        I am trying to apply a script to a sheet and Script Editor is not an option. I don't want to go outside Sheets to do this (like Creator) if it can be done inside Sheets.

      • monetizing the courses

        Can I add a price for course enrollment ?

      • Can we add zoho books features like invoices estemates etc on our zohocommerce website. When our customer login with their account they can able to see all books features in one place on zohocommerce?

        Can we add zoho books features like invoices estemates etc on our zohocommerce website. When our customer login with their account they can able to see all books features in one place on zohocommerce?

      • Next Page