LogoLogo
FeaturesHelp & ResourcesShowcasePricingLogin
Learn Section
Learn Section
  • Introduction
  • Getting Started
    • Finding your way around
    • Core concepts
      • Data Binding
      • Data Insertion
      • Dynamic Visibility
    • Creating and managing projects
      • Creating a Project
      • Saving a Project
      • Opening a Project
      • Version History
    • Templates
  • Components
    • Overview
    • Layout & Positioning
    • Charts
      • Line Chart
      • Column Chart
      • Bar Chart
      • Pie Chart
      • Combination Chart
      • Area Chart
      • Spline Chart
      • Step Chart
    • DataViz
      • Gauge
      • Word Cloud
      • Chord Diagram
      • Sankey Diagram
      • Schedule (Gantt)
      • Metric Tile
      • Progress Bar
      • Trend Icon
      • Mapbox
      • Loading Animation
    • Tables
      • Scorecard
      • Data Table
    • Controls
      • Push Button
      • Dropdown
      • Multi Select Dropdown
      • Listbox
      • Label Based Menu
      • Checkbox
      • Radio Button
      • Slider
      • Value Input
      • Print Button
      • URL Button
      • Screenshot
      • Hotspot
      • Date Picker
      • Toggle Switch
      • Scenario
    • Text
      • Text Label
      • Text Input
      • Text Area
    • Shapes
      • Rectangle
      • Ellipse
      • Line
    • Media
      • Image
      • Icon
    • Containers
      • Container
      • Web View
      • Repeat Container
      • Row Layout
      • Column Layout
  • Functions
    • Overview
    • Data Mover
    • External Parameters
    • Export to Excel
    • Export to PDF
    • Timer
    • Tableau Parameters
    • Browser Info
    • TextJoin
    • Unique List
  • Connections
    • Overview
    • Excel One Drive
      • Excel One Drive Read
      • Excel One Drive Writeback
    • Google Sheets
      • Google Sheets Read
      • Google Sheets Writeback
    • Ninox Connections
    • Smartsheets
    • CSV Connector
    • SAP Webi Connector
    • XDC Connections
    • Database Connections
    • Zapier Trigger
  • Spreadsheet
    • Overview
    • Spreadsheet functionality
    • Supported Spreadsheet Functions
    • Spreadsheet performance
  • Best practices for the Squirrel spreadsheet
  • Publishing & Sharing
    • Overview
    • Project Settings
    • Publishing to Squirrel Cloud
    • Publishing Locally
    • Using the Project Manager
    • Adding projects to PowerPoint
    • Adding projects to Tableau
    • Progressive Web Apps (PWA)
  • SETTINGS
    • Image Library
    • Custom Fonts
  • Account Management
    • Manage your account Profile
    • Understanding your Squirrel plan usage
    • Changing your Plan
    • Billing
    • How do I delete my account?
  • Frequent Questions
    • What data do you keep and for how long?
  • How-Tos
    • Overview
    • Add-ons
      • Add-on Documentation
      • Window Size – Add responsive behavior to your components
      • Window Size - Getting responsive behavior in the canvas
    • Adding your own Google Fonts
    • Chart title and Checkbox label text case formatting
    • Deleting functions and connections
    • Find & Replace Fonts
    • Getting a Mapbox API access token
    • Renaming a component, function or connection
    • Seeing Data from a Connector at Design time
    • Troubleshooting Projects in the Console
    • Using colors and color values
  • Tutorials
    • Create a temperature conversion app
    • Create a revenue growth app from an existing spreadsheet
    • Whack-A-Squirrel Game
    • Filtered Rows Insertion: Building a Filtered Selection
Powered by GitBook
LogoLogo

Explore

  • Home
  • Features
  • Pricing
  • Download Squirrel

Help

  • Learn
  • Community
  • Support
  • FAQ's

Updates

  • Blog
  • Events
  • Release Notes

Company

  • Contact Us
  • Privacy Policy
  • Terms of Use

Copyright © 2019 - 2024 InfoSol Ltd. All rights reserved.

On this page
  • Pie Chart Properties
  • DATA
  • GENERAL

Was this helpful?

  1. Components
  2. Charts

Pie Chart

This article describes the Pie Chart component and its properties.

PreviousBar ChartNextCombination Chart

Last updated 3 months ago

Was this helpful?

Who can use this feature?

All Squirrel365 plans include the Pie Chart component.

For more details, see our .

Squirrel 1.12 introduced a “Quick Set-up” tab on many property panels. The properties described on this page are available on the “All Properties” tab of the property panel. For more details on “Quick Set-Up” properties see

The Pie Chart displays data in the spreadsheet to the user. Use it to reveal trends or progress over time and show many different categories of data. In this article, we will be going over the Pie Chart, one of the many types of charts available to use within Squirrel.

Pie Chart Properties


DATA

  • Values - The area used to select the data in the sheet to bind to the chart. Do this by hovering over the box, and selecting the “bind to spreadsheet” button in the top-right corner.

  • Ignore End Blanks in Values - Toggle this property to ignore end blanks in a selected range. This can be used to hide data that has yet to be added. This is checked by default.

  • Labels - The area used to bind the data labels of the bound values. This range needs to be the same size as the Value range.

  • TOOLTIPS - this section is used to style the hover tooltips on the chart.

    • SHOW PERCENTAGE VALUE - this section styles the percentage values displayed on the tooltip. This is checked by default.

    • SHOW VALUE - This section styles the values displayed on the tooltip. This is checked by default.

  • COLORS - a subsection to apply colors to the individual series. These properties can be manually applied or bound to a cell in the spreadsheet.


GENERAL

  • Title - Used to change and customize the primary title on the Chart. Select the checkmark to hide/show.

  • Subtitle - Used to change and customize the secondary title on the Chart. Select the checkmark to hide/show.

  • Chart Background - Used to change the chart’s background, border color, and opacity.

    • Colour can be set in 3 ways

      • Clicking the colored rectangle and using the color picker

      • Typing in a color value (as HEX code)

      • Binding to a color value in a spreadsheet cell (formats included below)

        • A color name - e.g. red, green, blue-violet, steel blue

        • a HEX code - e.g. #ff2233

        • an RGB specifier - e.g. rgb(255,40,75)

        • A HSL specifier - e.g. hsl(120, 100%, 50%)

    • Opacity can be set in 3 different ways:

      • Using the spinner buttons

      • Typing in a value

      • Binding to value in a spreadsheet cell

  • Legend - Used to format the chart legend. The legend updates automatically when data is added. Select the checkmark to hide/show

  • Labels - format the chart labels displayed on the component. You can set the font, color, number formatting, and position.

  • Styling - adjust the shape and style of the Pie Chart, from the Conut Size to the Pie Shape and the Start Angle.

There are three property drawers available within the Pie Chart Properties Panel - these consist of a DATA drawer, a DATA drawer, and a DYNAMIC VISIBILITY drawer. This guide will not describe the dynamic visibility properties as these are generic to each visible component; a separate guide and tutorial on dynamic visibility can be found .

DATA INSERTION - a subsection to apply Data Insertion to the chart that specifies how data will be inserted into the spreadsheet when the user interacts with the running project. Select the checkbox to enable/ disable. Refer to for more on Data Insertion.

here
this article
pricing comparison matrix
this article