Create and customize charts to visualize data | Zoho Sheet Help Guide

Create and customize charts to visualize data

Create a chart

To create a chart:
  1. Select the range for which you need a chart.
  2. Click Insert > Chart. A chart is generated to best represent the data.
  3. Click the chart to open the contextual side panel.
  4. Edit or modify the chart type, design, title, legend and color scheme of the chart from within the side panel


Note:
  1. The available chart types are:
  2. Bar Chart
  3. Column Chart
  4. Line Chart
  5. Pie Chart
  6. Scatter Chart
  7. Area Chart
  8. Web Chart
  9. Bubble Chart
  10. Stock Chart
  11. Time series
  12. Guage Charts
  13. Pareto Chart
  14. Waterfall Chart
  15. Wordcloud Chart
  16. Histogram

Change the title of a chart

To edit a chart's title:
  1. Click on the chart.
  2. Click on the Chart icon in the side panel.
  3. Go to the "Customize" tab on the side panel.
  4. Select "Chart Title" from the drop down menu.
  5. Key-in the title you want to be displayed on the space provided.
  6. Alternatively, you can double click on the chart to directly enter in the edit mode.
  7. Once in the edit mode, you can click on the title and edit the text as you need.


Change color scheme of a chart

To edit a chart:
  1. Click on the chart.
  2. Click on the Chart icon in the side panel.
  3. Move to the "Custom" tab on the side pane.
  4. Click on the "Styles" drop down menu.
  5. Choose from the colour schemes provided, or create a custom style that suits your need.


Change the transparency of a chart

To edit a chart:
  1. Click on the chart.
  2. Click on the Chart icon in the side panel.
  3. Move to the "Custom" tab on the side pane.
  4. Click on the "Styles" drop down menu.
  5. Now change the transparency using the slider.


Aggregate elements of a chart

To aggregate elements of a chart:
  1. Click on the chart.
  2. Click on the Chart icon in the side panel.
  3. While on the "General" tab on the side panel, click on the "Aggregation" drop down menu.
  4. You can choose one of the six functions listed, based on which the chart elements will be aggregated.


Publish a chart

To publish a chart:
  1. Right click on the chart you want to publish, and choose Publish from the drop down.        
  2. Use the code snippet you get to embed or publish your chart.
  3. You can also choose to remove the public view of the chart by clicking Revert Publish from the menu.


Save a chart as an image

To save a chart as an image:
  1. Click Advance Options > Save As Image present in the menu.
  2. The chart is saved as a Portable Network Graphics (.png) image to your device.


Delete a chart

To delete a chart:
  1. Click Delete found in the menu when you select a chart.
  2. Alternatively, you can select the chart and hit the Delete key.



        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 FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile 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 FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG


                                    All-in-one knowledge management and training platform for your employees and customers.

                                              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


                                                                      • Desk Community Learning Series


                                                                      • Digest


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Glossary


                                                                      • Desk Marketplace


                                                                      • MVP Corner


                                                                      • Word of the Day


                                                                      • Ask the Experts


                                                                        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

                                                                                                                                • Working with pivot charts

                                                                                                                                  Pivot charts, like the name suggests, lets you visualize the data while simultaneously letting you slice and dice the data just like a pivot table. Like any other chart, you can even customize how a pivot charts looks.   Creating a pivot chart Click ...
                                                                                                                                • How to create charts

                                                                                                                                  Charts let you visualize your data and highlight patterns at a glance. Charts in Zoho Sheet come with a three-tab interface—Data, Design, and Format—that helps you create, design, format, and manage your charts. To create a chart Select the cell ...
                                                                                                                                • Create charts to visualize your data

                                                                                                                                  How to create a chart To create a chart: Select the range of cells you want to visualize. Go to Insert and select a chart type of your choice. Select the chart and click the Chart icon from the side pane to edit the chart type, design, title, legend, ...
                                                                                                                                • Create charts to visualize your data

                                                                                                                                  How to create a chart To create a chart: Select the range of cells you want to visualize. Go to Insert and select a chart type of your choice. Select the chart and click the Chart icon from the side pane to edit the chart type, design, title, legend, ...
                                                                                                                                • Create charts to visualize your data

                                                                                                                                  How to create a chart To create a chart: Select the range of cells you want to visualize. Go to Insert and select a chart type of your choice. Select the chart and click the Chart icon from the side pane to edit the chart type, design, title, legend, ...
                                                                                                                                  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