Link data to charts and tables in Zoho Show

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.

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

        • Syncing Timesheets between Projects and Desk

          All users able to see their own timelog entries from all apps in one place, synced immediately. All managers able to view total/all time entries from one place. This is something that has come up for us and multiple clients. Example: we have a client

        • Spell Check default language

          Hello All, Is it possible to set the Spell Check default language? I can't find it in the settings. Thanks a lot! Levente

        • Zoho Backstage 3.0 - Boostez vos événements avec des outils malins

          Zoho Backstage vous accompagne dans l’organisation d’événements réussis, avec des outils qui simplifient la planification, optimisent l’exécution et renforcent la connexion avec votre public. La version 2.0 a apporté une nouvelle interface, plus de flexibilité

        • Portal user activity reporting

          Aside from the metrics section in the admin dashboard, is there a way to view/create reports for portal user activity? Im looking for a more granular option to see exactly what users are utilizing the portal. Thanks!

        • Automation #11 - Auto Update Custom Fields with Values from Emails

          This is a monthly series designed to help you get the best out of Desk. We take our cue from what's being discussed or asked about the most in our community. Then we find the right use cases that specifically highlight solutions, ideas and tips to optimize

        • Admins to set Agents Picture

          Admins should not have to rely on agents to set a nice profile picture for them. Admins get the headshot pictures from HR and should be able to upload and set their picture, not rely on them to: 1) upload a picture at all 2) upload a good picture 3) upload

        • Time Tracking Reporting and Billing

          I wish for the time tracking module to be enhanced further. Currently it is independent of Support Plans and Contracts. Support Plans and Contracts are also mostly separate. We need a better dashboard of this with the ability to natively mark billed or

        • Enhanced Email Signature Folding

          We have departmental signatures setup which are great, however, when viewing ticket details, it gets very overwhelming when scrolling though threads and conversations where you scroll past ten different signatures of your own team, then ten signatures

        • How to add formatting in zoho.cliq.postToUser(...) message?

          In a CRM Deluge function, I'm trying to use the message formatting guidelines given here: https://www.zoho.com/deluge/help/cliq/posting-to-zoho-cliq.html#message-formats My message is: message: #Title text. The result in Cliq is: #Title text. (no large

        • How to add line breaks in zoho.cliq.postToUser(...) message?

          In a CRM function using Deluge I'm sending this message and attempting to add some line breaks but they are ignored. Is there another way to add these breaks? My message: message: New urgent task\nDescription \nThis is a fake description.\n A new line?

        • Zia Agents/End of Day Reports

          As a manager or owner it would be nice if Zia analyzed today's (or this week's tickets) and gave an end of the day report to management team. - what important tickets were worked on or submitted today? - what agents were unproductive today and answered

        • Project Cost Tracking

          I see there are questions/concerns that Zoho doesn't track costs to a tasks in a project. We are a manufacturer and are in the early stages of tracking costs to project. I would like to expand out the COGS Chart of accounts in Books and record costs via

        • How to record if the payment made is return due to transaction failed.

          So there is Bill of $2000, and a payments made transaction to clear the bill. The amount is actually deducted from bank account. However, a few days later, I found the bank returned only $1750 cause there are $250 bank service charge for this failed transaction.

        • Help Center Customization UI

          The customization screens for the help center needs the UI improved. It looks straight out of 2004. The Zoho Desk normal UI is great. All it takes is uniform fonts and colors across all parts of the tool... I compare this to Zendesk Guide.

        • Este domínio já está associado a esta conta

          Fui fazer meu cadastro na zoho e quando digitei meu domínio recebi essa mensagem que meu domínio estava associado a uma conta que eu nem faço idéia de quem seja. Como que faço pra resolver isso? Atenciosamente, Anderson Souza.

        • I need some help in Expenses Per Diem Policy

          this is my script written for restricting the PerDiem Components. Say if Lodging and Per Day Allowance both is selected from Per Diem Page then the report should gets auto rejected. When Im trying to executing it says the following error {"code":11,"message":"The

        • Adding Photos to Dashboards on Zoho Analytics

          I am creating a dashboard to showcase data from survey results from focus groups. I am creating a focus group participant profile tab where it is filtered by the name of the participant and showcases information about them using KPI widgets. I am running

        • What is the difference between Retainer invoice and Advance Payments?

          Retainer invoice seem like they are just advance payments with extra details. Instead of creating a Sales Order with order details, a retainer is created. It feels like they are a workaround to link advance payments with sales orders. Is there any advantage

        • Exporting record notes in bulk

          Hi team, Is it possible to bulk export the notes attached to a record? i.e to a CSV file or otherwise. Our use case is exporting all notes for our lead/account/Deal records. We have another system we'd like to import these notes to but I can't seem to

        • Field customization

          Hi Team Good day! I am a commission agent who sell and purchase goods from vendors, while in purchasing invoices I am not able to deduct the expenses such as commission and other expenses on actual amount. Kindly help me to customize the invoice based

        • vendors / customers with 2 different address and gst no

          Why can't we have option for more than one address and depending on the state option for more than 1 GST no. ? We have customers / vendors PAN india with different addresses and GST no. for different states.

        • Error: Invalid Element gst_no, Invalid Element gst_treatment, Invalid Element place_of_contact

          so i am creating a new contact post request and i want add gst infomation when amount is above 50000 and if pass gst info in request body then i get this errors > Error: Invalid Element gst_no, Invalid Element gst_treatment, Invalid Element place_of_contact

        • Add multiple Billing Addresses under one GST number

          My client owns multiple businesses in various locations but they all come under one GST. Is there a way to add multiple billing addresses for the same GST? Managing this by adding multiple Shipping addresses is not an option. The client wants the GST

        • Zoho Mail API - Upload Attachment

          https://www.zoho.com/mail/help/api/post-upload-attachments.html I followed the steps from the API documentation and wrote a backend in JavaScript to send emails. Normal emails are sent without any problems. However, I can’t send emails with attachments.

        • Unable to create custom fields for shipment order

          I'm unable to create custom fields for shipment orders, even though the custom fields are set up correctly. A request to the following endpoint: https://www.zohoapis.com/inventory/v1/settings/preferences/customfields?organization_id=${ZOHO_ORGANIZATION_ID}&entity=shipment_order

        • Kaizen #202 - Answering Your Questions | Testing and Using REST APIs in Widgets

          Hello Developers! Welcome back to a fresh week of Kaizen! Thank you for your active participation in sharing feedback and queries for the 200th milestone. This week, we will look at the following queries related to widget: Widget Testing Using REST API

        • Introducing the 'Send as Email' option on the Zoho Desk iOS mobile app

          Hello everyone! In the latest version(v2.10.2) of the Zoho Desk iOS app, we have brought in support for the 'Send as Email' option while creating a ticket. This feature enables you to reach out to the customers by sending outbound emails. The emails are

        • Zoho Forms Not Loading on Website – DNS Resolution Error

          Dear Zoho Support Team, User ID : 20069458731 We are experiencing an issue with the Zoho Form embedded on our website (https://vitel.com.tr/satis-destek-formu/). The form is not loading, and the following error message appears in the browser: “forms.zohopublic.eu

        • Data backup retention question/

          My zohocrm subscription gives me 2 full data backups per month. I have a scheduled backup configured to run twice a month. I just went to download my backup and i can't find it, it ran about 9 days ago... From what i can tell with google zoho only keeps

        • Basic Apple Watch App

          Sometimes I leave my phone behind. I will get push notifications that tickets are updated etc.. It would be nice to at least view them and do a few basic functions. reassign. public reply. private comment.

        • Look and Feel Uniformity

          Someone needs to go through the mobile app and match the look and feel of the web version. For example, it is global standard to highlight private notes as yellow background hue. Desk does that on web, but not on mobile. Mobile also has an odd blue icon

        • Managing two books in Zoho Books

          is it possible to effectively manage two separate books within Zoho Books? My organization is considering handling accounting for two distinct subsidiaries, and we would like to understand the best way to achieve this within the Zoho Books.

        • Display All Custom Buttons Without Dropdown on Record Page

          In my org's workflow we usually want to do some kind of quick action off of an individual record - i.e. of an individual contact, or individual deal. What we have always found a hindrance is the location of all custom buttons being in the drop down on

        • Zoho Sales Team - Extremely Slow Response Times

          Hi everyone, Has anyone else experienced unusually slow response times from Zoho’s sales team? I sent an email last night, and it’s been nearly 24 hours with no reply. While I understand delays can happen, this seems longer than expected for a sales inquiry.

        • Yodlee Bank Feeds

          I'm well aware of the many bank feed issues out there that haven't been resolved, but I'm looking for information on Rules in relation to bank feeds. U.S based, Bank of America user and prior to Yodlee all of my banking feeds and Rules worked seamlessly.

        • Unable to create custom function

          Unable to create custom function - Please check the screenshot for the details HERE IS THE FUNCTION!! try { // 1. Fetch the details of the approved Bill using its ID billDetails = zoho.books.getRecordById("Bills", organization.get("organization_id"),

        • Need a feature which can validate PAN from Income Tax Portal

          Hello Zoho, We need a feature which can help us validate PAN which is being entered in AR/AP Profiles to check if it is valid and display the name as per Income Tax so as to get rid of incorrect PAN into the systems. Please do the needful Thanks

        • PAN - Aadhar Link Status

          Can Zohobooks also get latest PAN-Aadhar Linking Status from Income Tax Portal ?

        • How do you get a counter signature after a form has been submitted?

          I would like to be able to get a signature on a form that has already been submitted. Is it possible? Currently when I try and get a signature after the form has been submitted i get an error saying "the field no longer available" .

        • Canvas translation

          We want to offer our CRM system to our users in English and Dutch. However, it seems that text in our deal Canvas isn't available for translation through the translation file. The same applies to the field tooltips. They don't appear in the translation

        • Next Page