Create sparklines | Zoho Sheet Help Guide

Create sparklines, the in-cell graphs.

What are sparklines?

Sparklines are in-cell graphs that represent a range of data. These sparklines help you quickly perceive the trend in the data. Sparklines can be further customized, on type of graph, color schemes and axes levels.

Create Sparklines

To create a sparkline -
  1. Select the range of cells you want to create a Sparkline for.
  2. Go to the Insert menu and select Sparkline.
  3. From there, click Create Sparkline and specify the cell in which you want the Sparkline to be in the Destination cell field.



Here are the types of Sparklines available.
  1. Line Graph.
  2. Column Chart.
  3. Win-Loss chart.

Edit Sparklines

  1. Click on the Sparkline.
  2. Click on the Sparkline icon on the contextual side panel.
  3. Alternatively, you can go to Insert, hover over Sparkline and select Edit Sparkline.


Delete Sparklines

  1. Click on the Sparkline
  2. Click on the Sparline icon on the contextual side panel.
  3. Under the Manage heading, click on the delete icon.
  4. You can choose to delete either the entire Sparkline group, or the selected one alone.


    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









                                        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

                                              Zoho Desk Resources

                                              • Desk Community Learning Series


                                              • Digest


                                              • Functions


                                              • Meetups


                                              • Kbase


                                              • Resources


                                              • Glossary


                                              • Desk Marketplace


                                              • MVP Corner


                                              • Word of the Day


                                                Zoho Marketing Automation

                                                  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 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

                                                                                                          • CELL

                                                                                                            Returns information about the address, format, or content of a given cell.   Syntax   CELL(info_type; cell_ref ) info_type: Text string that determines which information to return. E.g. "WIDTH" cell_ref: The reference of the cell whose information ...
                                                                                                          • Create a new blank spreadsheet

                                                                                                            To create a new blank spreadsheet, open the app and follow these steps: In the listing page, tap the + icon in the bottom bar. Choose the Blank Spreadsheet option from the listed gallery.
                                                                                                          • Create a named range

                                                                                                            To create a named range: Select the desired cell range. Go to  Under the Insert menu, choose Define Name. You can choose to define a cell range, an expression, or a constant value. Enter the desired values and tap Done.
                                                                                                          • Create a named range

                                                                                                            To create a named range: Select the desired range. Go to the icon. Under the Insert menu, choose Define Name. You can choose to define a cell range, an expression, or a constant value from the drop-down menu. Enter the desired value and tap Done.
                                                                                                          • Create a table

                                                                                                            What is a Table? Table is one of the best spreadsheet tools to group and analyze data swiftly. Format your data into tables for better visualization! To create a table: Go to Format > Table. Select a table style from the list of options. Mention 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