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
  • Word Cloud Properties
  • GENERAL
  • TEXT STYLING
  • CLOUD SETTINGS
  • INTERACTIVITY

Was this helpful?

  1. Components
  2. DataViz

Word Cloud

This article describes the Word Cloud component and its properties.

PreviousGaugeNextChord Diagram

Last updated 3 months ago

Was this helpful?

Who can use this feature?

All Squirrel365 plans include the Word Cloud 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 Word Cloud is a data visualization component that shows the popularity of words or phrases by making the most frequently used words appear larger or bolder than the other words around them.

Select Word Cloud from the Data Visualization category of the component library. Move the mouse over the canvas and click to add a word cloud to your project:

Word Cloud Properties


GENERAL

STRUCTURED ARRAY

  • Structured Source - with Structured Array selected a bind-only input field displays. An array example can be seen below:

TEXT STRING

  • Source - an input field that contains the text string to display on the component. This can be bound to a string of text in the spreadsheet.

  • Max words to display - defines the maximum number of words that can be displayed on the component.

  • Words to Exclude - defines the words to exclude from the word cloud.

  • Min word length - defines the minimum size a word has to be to display.

  • Include words with count greater than - defines words that display based on how many times they repeat in the text string.

CHART BACKGROUND

  • Fill - 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.

    • Individual Padding - selected this property to apply different amounts of padding to each of the component's edges. Each of these individual inputs can be manually edited or bound to the spreadsheet.


TEXT STYLING

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

  • Default Text Color – The button label will be shown in the color that matches the value entered in the property field.

    • Opacity – This determines the transparency of the button label.


CLOUD SETTINGS

  • Randomness - adjust the slider, or enter into the input field, to adjust the random generation of the word cloud display.

  • Allow words to be vertical - a check option to allow for words to display vertically, as well as horizontally

  • Heat Rules - select an option from the dropdown to apply heat rules to the values on the word cloud. This is set to None by default.

  • Color Range - applies color heat mapping to the values on the word cloud display.

    • Min color - sets the color for the text with smaller values tied to them.

    • Max color - sets the color for the text with larger values tied to them.

  • Opacity Range - applies opacity heat mapping to the values on the word cloud display.

    • Min opacity - sets the opacity for the text with smaller values tied to them.

    • Max opacity - sets the opacity for the text with larger values tied to them.

  • Show value - check this option to display the value beside the corresponding text value.


INTERACTIVITY

All these properties apply to the word cloud interactivity.

DATA TOOLTIPS

  • 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

  • Line height – Use this property to adjust the line spacing of the Text Label. Choose one of the options from the dropdown list.

  • Default Text Color – The button label will be shown in the color that matches the value entered in the property field.

    • Opacity – This determines the transparency of the button label.

  • Padding – This property defines the space between the component and the component border.

    • Individual Padding - selected this property to apply different amounts of padding to each of the component's edges. Each of these individual inputs can be manually edited or bound to the spreadsheet.

  • Number Format - Select an option from the dropdown to adjust the number formatting

  • Tooltip style -

    • Square corner - applies a square cornering to the tooltip

    • Rounded corner - applies a rounded cornering to the tooltip

  • Background Fill - a property to change the color of the tooltip 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 tooltip border.

    • Opacity - a property to change the opacity of the tooltip border.

  • Effects – Select an option from the dropdown box. The options are none and Drop Shadow. With Drop Shadow selected the following properties appear:

    • Color – this determines the color of the shadow

    • Opacity – this determines the opacity of the shadow

    • X-Offset – determines the horizontal position of the shadow (positive values move to the right, negative values move to the left)

    • Y-Offset – determines the vertical position of the shadow (positive values move down, negative values move up)

    • Blur – determines the blur of the shadow

DATA GAPS - ALL SERIES

  • Ignore Blank Cells - check this option to ignore blank cells within a selected data range.

The Word Cloud properties consist of GENERAL, TEXT STYLING, CLOUD SETTINGS, INTERACTIVITY, 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