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
  • Schedule (Gantt) Properties
  • GENERAL
  • STYLING
  • CATEGORY AXIS
  • DATE TIME AXIS

Was this helpful?

  1. Components
  2. DataViz

Schedule (Gantt)

PreviousSankey DiagramNextMetric Tile

Last updated 3 months ago

Was this helpful?

Who can use this feature?

All Squirrel365 plans include the Schedule (Gantt) component.

For more details, see our .

The Schedule (Gantt) component is a data visualization component used to display data as a calendar and help teams plan work around deadlines and properly allocate resources.

Select Schedule (Gantt) from the Data Visualization category of the component library. Move the mouse over the canvas and click to add a Sankey diagram to your project:

Schedule (Gantt) Properties


GENERAL

All these properties pertain to the General data display and background styling of the component.

DATA

  • Data source - an input that must be bound to a range in the spreadsheet. In the property panel, a sample data structure can be downloaded to display how the spreadsheet should look when bound to the component.

CHART BACKGROUND

  • Background Color - a property to change the color of the component background

    • 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

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

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

  • Padding – This property defines the space between the component and the component border. This can be applied to the Left, Right, Top, and Bottom edges.


STYLING

These properties apply to the styling of the component

BLOCK STYLE

  • Color Options

    • Use defaults - this applies the default colors to the component

  • Apply Colors to - select the series to apply the Schedule (Gantt) colors. This can be set to either the data Items or Categories. With either selected, the below list will populate with the respective list names.

  • Color

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

DATA LABELS

  • Display

    • Item - A check option to display the item description on the period blocks. This is checked by default

    • Period - A check option to display the time on the period blocks. This is checked by default.

  • Font – Choose a font style from the dropdown list

  • Size – Change the font size of the Text Label in 3 ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to a value in a spreadsheet cell

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

  • Text Color – The text will be shown in the color that matches the value entered in the property field. This can be set in 3 ways:

    • Clicking the colored rectangle and using the color picker

    • Typing in a color value

    • Binding to a color value in a spreadsheet cell

  • Opacity – This determines the transparency of the text. This property can be set in 3 different ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to value in a spreadsheet cell

  • Capitalization – Change the letter case of the Text Label content to the either uppercase first letter, all uppercase letters, or all lowercase. Unselecting all of the buttons will return the content to its original case format. The blue button indicates the current selection:

DATA TOOLTIPS

  • Display

    • Item - A check option to display the item description on the period blocks. This is checked by default

    • Period - A check option to display the time on the period blocks. This is checked by default.

  • Font – Choose a font style from the dropdown list

  • Size – Change the font size of the Text Label in 3 ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to a value in a spreadsheet cell

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

  • Text Color – The text will be shown in the color that matches the value entered in the property field. This can be set in 3 ways:

    • Clicking the colored rectangle and using the color picker

    • Typing in a color value

    • Binding to a color value in a spreadsheet cell

  • Opacity – This determines the transparency of the text. This property can be set in 3 different ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to value in a spreadsheet cell

  • Text alignment – Choose to align the text to the left, right, or center. The blue button indicates the current selection:

  • Capitalization – Change the letter case of the Text Label content to the either uppercase first letter, all uppercase letters, or all lowercase. Unselecting all of the buttons will return the content to its original case format. The blue button indicates the current selection:

  • Padding – This property defines the space between the Text Label border and the Text Label content. 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.


CATEGORY AXIS

These properties pertain to the category axis on the Schedule component.

LABELS

  • Font – Choose a font style from the dropdown list

  • Size – Change the font size of the Text Label in 3 ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to a value in a spreadsheet cell

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

  • Text Color – The text will be shown in the color that matches the value entered in the property field. This can be set in 3 ways:

    • Clicking the colored rectangle and using the color picker

    • Typing in a color value

    • Binding to a color value in a spreadsheet cell

  • Opacity – This determines the transparency of the text. This property can be set in 3 different ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to value in a spreadsheet cell

  • Capitalization – Change the letter case of the Text Label content to the either uppercase first letter, all uppercase letters, or all lowercase. Unselecting all of the buttons will return the content to its original case format. The blue button indicates the current selection:

TITLE

  • Category Axis Title - the entered text will be displayed as the title for the Category axis.

  • Font – Choose a font style from the dropdown list

  • Size – Change the font size of the Text Label in 3 ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to a value in a spreadsheet cell

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

  • Text Color – The text will be shown in the color that matches the value entered in the property field. This can be set in 3 ways:

    • Clicking the colored rectangle and using the color picker

    • Typing in a color value

    • Binding to a color value in a spreadsheet cell

  • Opacity – This determines the transparency of the text. This property can be set in 3 different ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to value in a spreadsheet cell

  • Capitalization – Change the letter case of the Text Label content to the either uppercase first letter, all uppercase letters, or all lowercase. Unselecting all of the buttons will return the content to its original case format. The blue button indicates the current selection:


DATE TIME AXIS

These properties pertain to the DateTime axis on the Schedule component.

LABELS

  • Font – Choose a font style from the dropdown list

  • Size – Change the font size of the Text Label in 3 ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to a value in a spreadsheet cell

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

  • Text Color – The text will be shown in the color that matches the value entered in the property field. This can be set in 3 ways:

    • Clicking the colored rectangle and using the color picker

    • Typing in a color value

    • Binding to a color value in a spreadsheet cell

  • Opacity – This determines the transparency of the text. This property can be set in 3 different ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to value in a spreadsheet cell

TITLE

  • Date Axis Title - the entered text will be displayed as the title for the Date Time axis.

  • Font – Choose a font style from the dropdown list

  • Size – Change the font size of the Text Label in 3 ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to a value in a spreadsheet cell

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

  • Text Color – The text will be shown in the color that matches the value entered in the property field. This can be set in 3 ways:

    • Clicking the colored rectangle and using the color picker

    • Typing in a color value

    • Binding to a color value in a spreadsheet cell

  • Opacity – This determines the transparency of the text. This property can be set in 3 different ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to value in a spreadsheet cell

  • Capitalization – Change the letter case of the Text Label content to the either uppercase first letter, all uppercase letters, or all lowercase. Unselecting all of the buttons will return the content to its original case format. The blue button indicates the current selection:

The Schedule (Gantt) properties consist of GENERAL, STYLING, CATEGORY AXIS, DATE TIME AXIS, 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 .

Get from data - this populates an input that can be bound to a series of colors in the spreadsheet. See for ways that colors can be formatted in the spreadsheet.

Bold Italics Underline selection panel
Bold Italics Underline selection panel
Bold Italics Underline selection panel
Bold Italics Underline selection panel
Bold Italics Underline selection panel
Bold Italics Underline selection panel
here
this article
pricing comparison matrix
Sample Data Structure, downloadable in the properties panel