Get AI recommended charts and pivots for your data

Get AI recommended charts and pivots for your data

What is Zia?

Zia, Zoho Sheet's Artificial Intelligence recommends personalized charts and pivots for your data. You can even ask queries in natural language about the data to Zia.

Look for Zia's suggestions

  1. Click on  in the side pane. By default, the insights tab will open.
  2. Edit the range to get contextually suggested charts and tables.
  3. Alternatively, after selecting the range, you can click on the Tools > Zia.
  1. Open Zia.
  2. Hover over the chart or table you want to add to your spreadsheet.
  3. Click on the "+" symbol that appears near the chart or table.
  4. Alternatively, you can simply click, drag and drop the charts from the side panel to your spreadsheet.


You can click on the "Zoom" symbol just beneath the "+" symbol to have a closer look at the chart or pivot table that you'd like to add before you do so.

Ask questions to Zia about your data

  1. Open Zia. 
  2. Enter your queries on the space labelled "Ask Zia".
  3. In the answer, you will find the result, along with a chart or a pivot table to represent it, or the  formula Zia used to get to the result.
  4. You can click and drag these formulas to drop them in the cell you choose.


Insights by Zia

In addition to charts and pivot table suggestions, Zia provides deeper insights to understand your data better.
  1. In the Zia side pane, by default, you can find the top 2 insights.
  2. To get a detailed analysis of your data, click Insights.


      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        Access your files securely from anywhere

          Zoho CRM Training Programs

          Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

          Zoho CRM Training
            Redefine the way you work
            with Zoho Workplace

              Zoho DataPrep Personalized Demo

              If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

              Zoho CRM Training

                Create, share, and deliver

                beautiful slides from anywhere.

                Get Started Now


                  Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                  BOOK A SESSION







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsEnterpriseOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceAccessible Forms
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Intake FormsLegalMobile App
                              Form DesignerHRMobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic Forms
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsEncrypted Forms

                              Secure Forms

                              WCAG

                                      Create. Review. Publish.

                                      Write, edit, collaborate on, and publish documents to different content management platforms.

                                      Get Started Now






                                                        You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                            Manage your brands on social media

                                                              Use cases

                                                              Make the most of Zoho Desk with the use cases.

                                                               
                                                                

                                                              eBooks

                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                               
                                                                

                                                              Videos

                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                               
                                                                

                                                              Webinar

                                                              Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                               
                                                                
                                                              • Desk Community Learning Series


                                                              • Meetups


                                                              • Ask the Experts


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner

                                                                Zoho Sheet Resources

                                                                 

                                                                    Zoho Forms Resources


                                                                      Secure your business
                                                                      communication with Zoho Mail


                                                                      Mail on the move with
                                                                      Zoho Mail mobile application

                                                                        Stay on top of your schedule
                                                                        at all times


                                                                        Carry your calendar with you
                                                                        Anytime, anywhere




                                                                              Zoho Sign Resources

                                                                                Sign, Paperless!

                                                                                Sign and send business documents on the go!

                                                                                Get Started Now




                                                                                        Zoho TeamInbox Resources





                                                                                                  Zoho DataPrep Demo

                                                                                                  Get a personalized demo or POC

                                                                                                  REGISTER NOW


                                                                                                    Design. Discuss. Deliver.

                                                                                                    Create visually engaging stories with Zoho Show.

                                                                                                    Get Started Now









                                                                                                                        • Related Articles

                                                                                                                        • How to get data refining suggestions from Zia?

                                                                                                                          Zia analyzes the selected data set and provides data cleaning and data quality suggestions to check and remove missing values, duplicate records and columns with multiple data types. To get data refining suggestions from Zia: Select the data or cell ...
                                                                                                                        • How to get formatting suggestions from Zia?

                                                                                                                          Zia analyzes the selected data and provides conditional formatting, picklist, and checkbox suggestions. To get formatting suggestions from Zia: Select the data or cell range for which you wish to get suggestion from Zia. From the side pane, go to > ...
                                                                                                                        • Create and customize charts to visualize data

                                                                                                                          Create a chart To create a chart: Select the range for which you need a chart. Click Insert > Chart. A chart is generated to best represent the data. Click the chart to open the contextual side panel. Edit or modify the chart type, design, title, ...
                                                                                                                        • Get insights from Zia

                                                                                                                          Insights by Zia provides you with recommended charts, pivot tables, and insights about your data. You can get instant answers to your data-related questions. To get insights: Select the desired data to analyze. Go to ... > Zia. Scroll through the Zia ...
                                                                                                                        • Get insights from Zia

                                                                                                                          Insights by Zia provides you with recommended charts, pivot tables, and insights about your data. You can also ask data-related questions and get instant answers.   To get insights: Select the desired data to analyze. Go to ... > Insights Scroll the ...
                                                                                                                          Wherever you are is as good as
                                                                                                                          your workplace

                                                                                                                            Resources

                                                                                                                            Videos

                                                                                                                            Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                            eBooks

                                                                                                                            Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                            Webinars

                                                                                                                            Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                            CRM Tips

                                                                                                                            Make the most of Zoho CRM with these useful tips.



                                                                                                                              Zoho Show Resources