Link data to charts and tables in Zoho Show
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.
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.
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Loshini D
Kiruthika S
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
customize payment page
Is there a way to customize, other than the theme colour, the payment page that customers are taken to from invoices? I can't seem to find a way. I just don't like the formatting of the current page and would like to make it look better. I've looked atFeature Request: Stripe Terminal Integration
I would like to request the addition of Stripe Terminal integration to Zoho Books, which will help process in-person payments. While Zoho Books already supports online payments through Stripe, extending this functionality to include Stripe Terminal wouldecommerce intergation
I am setting up my eCommerce website. I am planning to use zoho crm with zoho books. What do I need to syncs the data from my website to crm and books? I am using zoho crm and books at this moment but I would like the ecommerce as a separate business.Zoho Bookings <> CRM integration
Hello Zoho community! We are enabling our Zoho Bookings <> CRM integration. What is the workflow if the integration detects that the contact already exists in the CRM? Does it create a duplicate record? Overwrite the record? Merge the record? (in thisDeluge - forward incoming email with original attachments and content but new subject
I'm working in ZohoMail with a 10GB paid account. Using a filter and a custom function, I can send a new mail with the original email content and a new subject, but I'm struggling to find how to attach the original attachment to a new mail - or even toEmail not arriving
This is now the second time I have had this issue with zoho mail filtering 2FA codes from outside services. Currently the problem is with and example of this email from OpenAI: Delivered-To: david@holidaycoro.com Received-SPF: pass (zohomail.com: domainMobile Display Issues on Zoho Sites After Recent Update
Hello! I’m currently facing an issue with my Zoho website that I created for my small business. After the recent updates, I’ve noticed that my site is not displaying correctly on mobile devices. Specifically, the layout appears distorted, and some elementsClient Script also planned for Zoho Desk?
Hello there, I modified something in Zoho CRM the other day and was amazed at the possibilities offered by the "Client Script" feature in conjunction with the ZDK. You can lock any fields on the screen, edit them, you can react to various events (field6 time-saving tips for working with tables in Zoho Writer
Tables have always been the best way to represent data. They help you structure and categorize information systematically and present them in a simpler way. While tables in Zoho Writer are easy to implement, some tasks might not be that obvious. Here are some time-saving tips to help you work better with tables in Zoho Writer: 1. Insert Multiple Rows / Columns in a Table Adding more rows and columns is the most common action performed while working with tables. Instead of using the Table tab,Unified customer portal login
As I'm a Zoho One subscriber I can provide my customers with portal access to many of the Zoho apps. However, the customer must have a separate login for each app, which may be difficult for them to manage and frustrating as all they understand is thatAdd Prebuilt "Partner Finder" Template with Native Zoho CRM Integration in Zoho Sites To: Zoho Sites Product Team
Hi Zoho Team, We hope you're doing well. We would like to request a prebuilt "Partner Finder" template for Zoho Sites, modeled after your excellent implementation here: 🔗 https://www.zoho.com/partners/find-partner-results.html ✅ Use Case: Our organizationAdd Built-in "Partner Finder" / "Contractor Directory" Tab to Zoho Desk Help
Hi Zoho Team, We hope you're doing well. We would like to request a new feature for the Zoho Desk Help Center: A built-in, configurable "Partner Finder" / "Contractor Directory" tab or section, similar in concept to your own Zoho Partner Finder at: 🔗Can't get sender adress to work
Hi, I am having some trouble getting the sender adress to work for responses on tickets. I would like to configure a sender adress that is different from the zohodesk emailadress that is normally used. These are the steps I have followed: 1. Add a newQuestion Regarding Deleted Reports in Zoho Desk Analytics
Dear Zoho Desk Support Team, I hope this message finds you well. We have a question regarding the Analytics module in Zoho Desk, specifically related to deleted reports/dashboards. We would like to understand the following: Is there a recycle bin, recoveryAdd an option to start zobot when user clicks the Chat with Us button
I would like to have an option to start the zobot when user clicks on "Chat with us" button when chat widget is maximized that way visitors could see first the homepage and decide which channel they would like to use to connect, or to see the quicke helpZoho Books - Feature Request - Provide "Show PDF View" toggle on Invoice records
I have noticed it is possible to activate or deactivate the PDF preview on some records but not all. This would be very helpful on Invoices when a custom template is being used and the PDF preview does not represent the output file. Not available on:Incorrect Handling of XLSX data
Trying to import an XLSX schedule of bills into Zoho Books I ran across the problem of date formatting. To replicate: Build a CSV file with bill dates in whatever format you like and import it - this should work if you match the "dd/MM/yyy" etc. formatHow do I modify the the incoming/current call popup? I can modify other call pages but not that one.
I want to modify the incoming and active call popup on the crm to include customer relevant information, such as purchase history or length of relationship. Under modules and fields, I don't seem to see active call as a choice to modify, only the mainDisable Smart Filters By Default
The smart filters "feature" is causing confusion for Zoho Mail users. New emails should be delivered to the inbox unless they have specifically opted to redirect them somewhere else. People don't understand that new emails might be waiting in a randomSet File Upload fields as mandatory
Currently the CRM for some reason lacks the ability to set a file upload field as mandatory So we have an issue We have a requirement that before a Deal stage is set as Deal is Won the member needs to upload a file Now for some weird reason in Zoho IIntroducing Zoho PDF Editor: Your free online PDF editing tool
Edit your PDFs effortlessly with Zoho PDF Editor, Zoho's new free online PDF editing tool. Add text, insert images, include shapes, embed hyperlinks, and even transform your PDFs into fillable forms to collect data and e-signatures. You can edit PDFsEmpowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM
Hello everyone, We’re excited to introduce cross-module criteria support in custom views! Custom views provide personalized perspectives on your data and that you can save for future use. You can share these views with all users or specific individualsShare saved filters between others
Hi, I am in charge to setup all zoho system in our company. I am preparing saved filters for everybody, but the only one can see its me. How can others see it? ThanksUpdate Lead Status in Zoho CRM When a Meeting is Booked via Microsoft Bookings
Hi everyone, I’m trying to streamline our lead management process and would like to automatically update the Lead Status in Zoho CRM whenever a meeting is booked through Microsoft Bookings. Has anyone successfully implemented this kind of integrationAdding Columns to Reports
Hi, Is it possible to choose fields to be added as columns in the reports? Thank you.How do I automatically assign the project owner for all tasks in Zoho Projects?
I have been researching for days on how to automatically assign all the tasks to the project owner on creation of the project in Zoho Projects. I have been having to go in and manually change all the task owner from 'unassigned' to the owner of the projectImport from Linkedin
Please provide a way to enable importing contact information for Contacts and Companies from Linkedin? ThanksHelp Needed with Creating Close % Reporting
Now that our company has a good data set to work with we want to use ZCRM reports ways to track the performance metrics we have established. Specifically, I want to be able to calculate closing % for individual salespeople and individual support people.Canvas: Add Sections to Detail View
Currently it is only possible to add fields to a canvas detail view. This makes Canvas hard to maintain, because everytime we add a field to our system, someone needs to go into the canvas view and add it there as well. This leads to additional work andCRM Kiosk - Action for GetRecords
I have a Kiosk screen with GetRecords and want to use the selected records in a custom function. My particular case is to set a lookup value on the selected records. Generally speaking though, I want to work with the selected records in a function. ICreate static subforms in Zoho CRM: streamline data entry with pre-defined values
Last modified on (9 July, 2025): This feature was available in early access and is currently being rolled out to customers in phases. Currently available for users in the the AU, CA, and SA DCs. It will be enabled for the remaining DCs in the next coupleExtract Archived Projects using Zoho Projects API
In my organization we archive the projects when they are already completed, charged, invoiced, so that only those that are still pending process remain active. I need to access all projects (active and archived) from an external system, but the API v3Email for customer to provide payment information
Is there a way for customers when you set up a subscription to get an email that prompts them to put in their billing information to start their subscription? Also, can you show the subscription in their portal?Unable to display field label from a hidden Single Line Textbox in Description
Hi folks, I'm unable to display my hidden field, e.g. ${zf:SingleLine4} , in my description. I'm pre-filling this hidden Single Line Text box via "Field Alias - Pre-fill URL" settings. I noticed that my decimal form fields work, e.g. ${zf:Decimal}, andZoho Books | Product updates | July 2025
Hello users, We’ve rolled out new features and enhancements in Zoho Books. From plan-based trials to the option to mark PDF templates as inactive, explore the updates designed to enhance your bookkeeping experience. Introducing Plan Based Trials in Zohotransforming 1D tables to 2D and the other way round
Does Dataprep have tools to convert 1D tables to 2D tables and the other way round? The actions that are commonly called "pivot" and "melt". What I mean is transitioning between these two kinds of table: 2D id ____ name ____ surname ____ age 00 ____ MattMore context, fewer tabs: View lookup modules' data within a CRM Canvas page
Hello everyone, How often do your users juggle multiple browser tabs just to piece together the full context of a record? This update can make their lives easier. You can now add lookup modules' fields to a Canvas detail view page and a Canvas list viewLookup fields
Is there any way to add Lookup fields to Zoho FSM -- I do not see the option but I see default lookup fields in different modulesZoho Analytics - Bill Table
Hi I am new to Zoho and mainly work in Books. Recently learned of Zoho Analytics and am exploring it to create reports that would be useful for me. For example, I want to create a bills cash forecast by week for cash flow planning. When I start to createSudden Layout Issue After Last CSS Update for ZML (Temporary Fix Inside)
Hi, Our clients have noticed today that every section laid out with ZML suddenly shows an unwanted top padding/blank space that interrupts the user screens. It appears that Zoho has changed the default CSS for the .zcp-col.zcp-panel-rowtype-auto element.Next Page