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
  • Gauge Properties
  • INDICATOR SERIES
  • GENERAL
  • SCALE

Was this helpful?

  1. Components
  2. DataViz

Gauge

This article describes the Gauge component and its properties.

PreviousDataVizNextWord Cloud

Last updated 3 months ago

Was this helpful?

Who can use this feature?

All Squirrel365 plans include the Gauge 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 Gauge is a data visualization component that displays a value on a dial and compares it against certain thresholds.

Select Gauge from the Data Visualization category of the component library. Move the mouse over the canvas and click to add a gauge to your project:

Gauge Properties


INDICATOR SERIES

The Indicator series properties apply to Gauge functionality, including indicator points, styling, and labeling.

  • Indicator Series - A list containing all created series that display on the Gauge component

    • Name - a property that defines the selected series' name. This property can be bound to the spreadsheet

    • Value - a property that defines the value displayed on the gauge for the selected series. This property can be bound to the spreadsheet.

STYLING

  • Type - A dropdown to select the indicator type on the component

  • Indicator Fill - a property to change the color of the indicator

    • Opacity - a property to change the opacity of the indicator fill

  • Indicator Border - a property to change the color of the indicator border. This is checked by default. Uncheck to disable the indicator border.

    • Opacity - a property to change the opacity of the indicator border. This is checked by default. Uncheck to disable the indicator border.

    • Indicator Border Width - a property to change the width of the indicator border. This property is not visible if the border is unchecked.

  • Center Size - A property to adjust the size of the gauge center point.

  • Center Fill - a property to change the color of the gaude center point color.

    • Opacity - a property to change the opacity of the gauge center point

  • Center Border - a property to change the color of the gauge center point border. This is checked by default. Uncheck to disable the indicator border.

    • Opacity - a property to change the opacity of the gauge center point border. This is checked by default. Uncheck to disable the indicator border.

    • Center Border Width - a property to change the width of the gauge center point border. This property is not visible if the border is unchecked.

DATA LABEL TEXT

  • Gauge Value Shown - a dropdown to change which of the created indicator series is displayed as the value on the gauge.

  • Font - Choose a font style from the dropdown list.

  • Size – Change the font size of the text.

  • B I U – Use these toggle buttons (bold, italic, underline) to change the format of the button label. When any of these is toggled on, the button is blue:

  • Text Color - The value will be shown in the color that matches the value entered in the property field.

    • Opacity – This determines the transparency of the text

  • Position - select the value position from the dropdown. The value can be positioned Outside or Inside the gauge component.

  • Padding - the value will adjust based on the padding set.

  • Number Format / Decimal Places - these properties control the format used to display the value

  • Use thousands separator - check to apply a delimiter to larger values.


GENERAL

The General properties apply to the component's styling and appearance, including the shape, title, and section colors.

GAUGE STYLE

  • Style -

    • Full - adjusts the gauge component to display a full gauge

    • Half - Up - displays the component as a top half

    • Half - Down - displays the component as a bottom half

    • Half - Left - displays the component as a left-half

    • Half - Right - displays the component as a right-half

TITLE

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

  • Font - Choose a font style from the dropdown list.

  • Size – Change the font size of the push button label.

  • B I U – Use these toggle buttons (bold, italic, underline) to change the format of the button label. When any of these is toggled on, the button is blue:

  • Text Color - The value will be shown in the color that matches the value entered in the property field.

    • Opacity – This determines the transparency of the text

  • Capitalization - Change the letter case of the label text content to either uppercase first letter, all uppercase letters, or all lowercase. Unselecting all of the buttons will return the content to its original case format.

  • Padding – This property defines the space between the component border and the component. It can be set in 3 ways:

    • The blue button indicates the current selection.

    • Typing in a value.

    • Binding to value in a spreadsheet cell.

ALERTING -

A subsection to apply Alerting to the chart line markers. Select the checkbox to enable/ disable.

  • From - the minimum value set for the corresponding alerting range

  • To - the maximum value set for the corresponding alerting range

  • Fill - the color set to display the corresponding alerting range.


SCALE

  • Min - an input property to enter the minimum value on the gauge scale

  • Max - an input property to enter the maximum value on the gauge scale

AXIS LABEL TEXT

  • Font - Choose a font style from the dropdown list.

  • Size – Change the font size of the push button label.

  • B I U – Use these toggle buttons (bold, italic, underline) to change the format of the button label. When any of these is toggled on, the button is blue:

  • Text Color - The value will be shown in the color that matches the value entered in the property field.

    • Opacity – This determines the transparency of the text.

  • Position - select the value position from the dropdown. The value can be positioned Outside or Inside the gauge component.

  • Padding - the value will adjust based on the padding set.

AXIS LINE

  • Axis Line - The line will be shown in the color that matches the value entered in the property field.

    • Opacity – This determines the transparency of the axis line.

  • Weight - the weight of the line will match the pixel value entered in the property field.

SCALE MARKER

  • Color - The scale markers will be shown in the color that matches the value entered in the property field.

    • Opacity – This determines the transparency of the scale markers.

  • Weight - the weight of the scale markers will match the pixel value entered in the property field.

The Gauge properties consist of INDICATOR SERIES, GENERAL, SCALE, and DYNAMIC VISIBILITY drawers. 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 .

here
pricing comparison matrix
this article