Build applications

Charts

In this course, you’ll learn how to include charts to your SpreadsheetWeb application. SpreadsheetWeb supports various types of charts including line, bar,…

Start course
Lessons
9
Level
Intermediate
Format
Self-paced
Course contents9 lessons
Course overview
  1. 01Data Range Selection
  2. 02Chart Types
  3. 03Axis Properties
  4. 04Chart Labels
  5. 05Chart Tooltips
  6. 06Chart Legend
  7. 07Chart Color Scheme
  8. 08Multiple Field in Charts
  9. 09Chart Animations

In this course, you’ll learn how to include charts to your SpreadsheetWeb application. SpreadsheetWeb supports various types of charts including line, bar, scatter, pie, donut, combo etc.

Requirements

  • A SpreadsheetWeb Control Panel account. You can signup for a trial account here.
  • Your spreadsheet containing named ranges for all inputs and outputs you would like to use in the web interface of your application.

Course curriculum

What you’ll learn

  1. 01
    Data Range SelectionDesigner applications have data visualization support, where you can display static or dynamic data on the user interface. SpreadsheetWEB uses data a bit…
  2. 02
    Chart TypesCharts in designer fall into four groups: Single-axis, Multi-axis, Special, and Combo charts. Each chart type supports certain properties and you will see…
  3. 03
    Axis PropertiesThere are mainly four types of charts in designer applications, and each chart group features different options for customizing their look-and-feel. To…
  4. 04
    Chart LabelsLabels in this context refer to the data points shown on the chart area itself. For customizing the Axis Labels, please see the previous video. The labels…
  5. 05
    Chart TooltipsTooltips are text boxes shown on the chart area when you hover your mouse over any of the data points. This feature can be especially useful for when you…
  6. 06
    Chart LegendThe chart Legend is an indicator of the data points displayed on the chart area. The legend area lists the names of each item and their corresponding colors…
  7. 07
    Chart Color SchemeYou can configure the chart colors by clicking the chart when you’re on the User Interface Designer, and pressing the blue Edit Color Scheme button on the…
  8. 08
    Multiple Field in ChartsThis help pages demonstrates how to use the Multiple Field in designer charts to display several variations of a chart inside one chart area.
  9. 09
    Chart AnimationsAnimations can be useful in displaying a change over time or by groups of the data shown on a chart. When enabled, an animated chart will cycle through each…