• search
  • Contact Sales
  • Support
    • Online Help
    • Community Forum
    • Contact Support
  • Log in
Get a Demo Try Free
High Contrast
Caspio logo Help
Try Free
  • High Contrast
  • search
  • Contact Sales
  • Support
    • Online Help
    • Community Forum
    • Contact Support
  • Log in
Get a Demo Try Free
  • Help Center
  • Application Design
  • Charts
  • Creating and Configuring Charts
  • Launch Your Caspio Journey
  • Create Applications
    • Applications Overview
    • Creating Apps With Bridge
      • Bridge App Overview
        • Creating a New App Container
        • Importing an App
        • Exporting an App
        • Deleting an App
        • Shared Objects
        • Backing Up Your Applications
        • Sharing an App with Another Account
        • App Parameters
          • Adding App Parameters
          • Managing App Parameters
          • Using App Parameters
      • Authentication
        • Setting Up User Permissions in Your App
        • Adding a Logout Link
        • Record Level Security
          • Create a Workflow using Record Level Security and Filtered Dropdown
          • Restrict Access to Data by User or Role
          • Filter Lookup Dropdown or Listbox Based on User or Role
        • Stamp a Record with User Profile Data
        • OpenID
        • Create a Standalone Login Screen
        • Hiding Multiple Login Forms
      • DataPages
        • What is a DataPage?
        • DataPage Types
        • Forms
          • Submission Forms
          • Update Forms
          • Password Recovery Forms
          • Form Element Types
          • Conditional Forms
          • Child Forms
          • Accepting Payments in Your Application
        • Reports
          • Creating a Report DataPage
          • Comparison Types in Report DataPages
          • Search by Distance
          • Report Page Results Layout
          • Interactive Reporting Options
          • Pivot Table Reports
          • Counting the Number of Times a Record Has Been Viewed
          • Display a Field Data as Hyperlink
          • Fixed Rows and Columns
          • Making the Search Results Downloadable as PDF
          • Editing Data Through My Details Page
          • Making the Details Downloadable for Users
          • Data Editing Options in Reports
          • Combined Chart and Report
          • Adding “Today” to “After Now” or “Next X Days” Criteria
          • Filtering Reports Based on an Expiration Date
          • Advanced Reporting
            • Calculations in Reports
            • Data Grouping
            • Totals and Aggregations
            • Calculated Fields and Datediff Function
        • Charts
        • Calendars
          • Calendar DataPage – Monthly Example
          • Calendar DataPage – Weekly Example
        • HTML Pages
        • DataPage Components
          • Dropdowns and Listboxes
          • Cascading Elements
          • Calculated Values
          • Field Configuration Options
            • Field and Column Width
            • Placeholder Text
            • Rollover Hints – Mouse-Over Help Icon
            • Image Auto-Rotation
          • DataPage Header and Footer
          • HTML Blocks
          • Disabling HTML Editor in DataPage Header/Footer and HTML Blocks
          • Field Formatting Options
          • Custom Date Formatting
          • Multi-column and Sections
          • CAPTCHA
          • Virtual Fields
          • Setting up Default Values
          • AutoComplete
        • Managing DataPages
          • Modifying DataPages
          • Previewing DataPages
          • Moving DataPages
          • Copying DataPages
          • DataPage Revisions
          • DataPage Folders
          • Exporting and Importing DataPages
          • Moving Existing DataPages To a New App
        • Responsive DataPages
          • Responsive DataPage Prerequisites
          • Responsive Behavior on Tablet and Mobile
          • Modifying Styles for Tablet and Mobile
        • AJAX Loading
        • PDF Download
          • Adding a text watermark
          • Adding an image watermark
          • Adding page breaks to details page
          • Adding header and footer
        • Best Practices in Creating Caspio Applications
      • Notifications
        • Email Notifications
          • Verifying Email and Domain
          • Configuring Email
          • Setting Up Dynamic or Conditional Notification Emails
        • SMS Notifications
          • Configuring the SMS-enabled Countries
          • Configuring SMS
          • Adding SMS Sender Name
      • Parameters
        • Parameter Types
        • System Parameters
        • Passing Parameters through Caspio
        • Displaying Parameters
        • Parameters as Query String Values
        • Receiving Parameters
        • Resetting Parameters
        • Passing Multiple Values in One Parameter
        • Formatting Parameters in Email Body and HTML Blocks
        • Parameters in Dropdowns, Listboxes and Radio Buttons
        • Custom Filter Elements
      • Connections
        • SAML Single Sign-On
        • Setting Up ID Services
      • Styles
        • Creating or Editing a Style
        • Layout Options
        • Fix the Width of the DataPage
        • Button Alignment
        • Field Alignment
        • Border Options
        • Using Google Web Fonts
        • Glossy Heading Text
        • Gradient Backgrounds for DataPages
        • Gradient Backgrounds for Fields
        • Replace Links to Records with Images
        • Replace Standard Buttons with Images
        • Change the Color of Field Error Labels
        • Change Text on a Button
        • Put Multiple Fields on One Line
        • Styling Advanced Reports
        • Add Rounded Borders to the Form and Fields
        • Use an Image as Form Background
        • Fix the Width of Labels and Data in List and Gallery Reports
        • Customize the ID Service Icon of the Login Screen
      • Localizations
        • Creating or Editing a Localization
        • Handling Arabic, Hebrew and Other Right-to-Left Languages
        • Formatting Options
        • Using Localization Feature to Improve Usability
        • Format Types
      • Files and Images
        • Uploading Files and Images
        • FileStor CDN
        • Managing Files
        • Bulk File Import and Export
        • Creating Thumbnails with the Image Resizer
        • Using Files in DataPages
        • Orphan File Cleanup
    • Creating Apps With Flex
      • Flex Overview
      • Roles
        • Creating New Roles
        • Adding Users and Groups to Roles
        • DataPart Display Based on the User Role
        • Editing Role Permissions
          • User’s Own Records
          • Custom Access
        • Removing Users and Groups from Roles
        • Deleting Roles
      • Application Design
        • Segments
          • Editing Segment Settings
          • Themes and Widgets
        • Adding AppPages
        • AppPage Types
        • Moving DataParts
        • Resizing DataParts
        • Adding DataParts
        • Forms
          • Form Elements
          • Search Form
          • Submission Form
          • Details/Update Form
        • Reports
          • Tabular Report
          • Card Report
          • Pivot Table
        • Sign-up Form
        • Charts
          • Creating and Configuring Charts
          • Chart Display Options
        • Text/HTML
        • Data Filters
          • Creating Filters
        • Calculated Values in Flex DataParts
        • Communication Between DataParts
        • Designing User-Friendly Navigation Between AppPages
      • Parameters
        • Inserting Parameters
        • Application Parameters
        • Adding Support for Lookup Values in Data Source Parameters
        • Stamping Records with User ID
      • Branding
      • Flex FAQ
  • Manage Users and Groups
    • Directories Overview
      • User Authentication in Directories
      • Converting Tables to Directories
      • Creating Directories
    • Directory Users
      • User Status Overview
      • Creating Users
      • Activating Users
      • Adding Users to Groups
      • Resetting User Passwords
      • Resetting Two-Factor Authentication
      • Suspending and Unsuspending Users
      • Changing User Sign-In Method
    • Directory Groups
      • Creating Groups
      • Modifying Groups
      • Deleting Groups
    • Directory Security
      • Session Management
      • Turning On Two-Factor Authentication
      • Customizing Directory Security Policy
      • Redirecting to Custom URLs After Sign-in and Sign-out
    • Directory User Portal
    • Directory Emails
    • Identity Providers
      • Adding Identity Providers
        • Tutorial: Adding Microsoft Entra ID (formerly Azure AD) Identity Provider
        • Tutorial: Adding Okta Identity Provider
        • Tutorial: Adding OneLogin Identity Provider
      • Editing Identity Providers
      • Deleting and Disabling Identity Providers
      • Configuring Single Logout
    • App Connections
      • Creating App Connections 
        • Authenticating Users to Caspio Apps in Multiple Accounts Using a Single Directory
        • Tutorial: Adding HubSpot App Connection
        • Tutorial: Adding BambooHR App Connection
        • Tutorial: Adding Slack App Connection
      • Managing App Connections 
      • Deleting and Disabling App Connections
  • Manage and Organize Your Data
    • Data Management Overview
    • Tables and Views
      • Creating Tables
      • Modifying a Table’s Design
      • Removing Blanks From a Dropdown or Listbox
      • Lookup Tables
      • Views
        • Creating a View to Filter Data
        • Creating a View to Join Tables
        • Self-Join Views
        • Modifying Views
        • Importing and Exporting Views
    • Data Types
      • List Data Types
      • Function Reference
      • Adding a Formula Field in a Table
      • Managing Files With the Attachment Data Type
    • Managing Data in Datasheet
      • Find and Replace Specific Values
      • Filtering Data
      • Downloading Table or View Data
    • Database Relationships
      • Relationship Settings
    • Importing Data
    • Exporting Data
    • Sharing Data Between Apps
    • Best Practices for Designing Databases and Tables
    • Logs
      • Managing Logs
        • Logs Retention Period
      • App Access Logs
      • Directory Logs
      • Email Logs
      • Integrations Logs
      • Payment Logs
      • SMS Logs
  • Leverage AI
    • AI Assistant Overview
  • Automate Tasks and Workflows
    • Automations Overview
    • Triggered Actions
      • Creating a Triggered Action
        • Actions
          • UPDATE
          • DELETE
          • INSERT INTO
          • SEND EMAIL
          • SEND SMS
        • Data
          • SELECT
        • Logic
        • Loops
        • Text
        • Number
        • Date
        • Variables
    • Tasks
    • Data Import/Export Tasks
      • Data Import Tasks
      • Data Export Tasks
      • Configuring a Repository Site
      • IP Addresses for Data Import/Export Tasks
      • Data Import/Export Tasks Tips and Best Practices
  • Generate PDF Documents
    • Document Generation Overview
    • Creating Templates
    • Mapping Fields in Templates
    • Template Field Types
    • Configuring Template Settings
      • Formatting Field Values
      • Adding Watermarks
      • Encrypting PDF Documents
      • Configuring PDF Document Properties
      • Changing PDF File for a Template
    • Enabling Document Generation in Applications
    • Managing Templates
  • Integrate and Extend Your Apps
    • Integrations Overview
    • Webhooks
      • Getting Started with Webhooks in Caspio
      • Webhooks Rules and Limitations
      • IP Addresses for Webhooks
      • Creating and Managing Webhooks
        • Configuring Call Throttling
      • Creating and Managing Events
        • Event Types
        • Activating or Deactivating Events
      • Testing Webhooks
    • Extensions
      • AI-Powered GPT Connect
      • Extension for Slack
      • QR Code Generator
      • Barcode Generator
    • Web Services API
      • Creating a Web Services API Profile
      • Authenticating REST API
      • Important Header Parameters
      • Special Considerations
      • Error Handling
      • Swagger UI
      • Migration from REST API v2 to v3
    • Integration with Make
    • Integration with Zapier
  • Deploy Your Apps
    • Deploying Bridge Apps
      • General Deployment Guide
      • Remove iFrame Border and Change Size
      • Block Access to DataPages by IP Address
    • Deploying Flex Apps
      • Mapping a Friendly Subdomain
  • Manage Account and Billing
    • Account Settings
    • Account Users, Groups and API Profiles
      • Inviting New Account Users
      • Creating Groups for Account Users
      • Managing Permissions
      • Changing Account Owner
    • Changing Your Plan
    • Updating Payment Information
    • Payment History
    • Custom Domain
    • Account Notifications
    • Resource Usage
    • Caspio ID
      • Managing Your Caspio ID
      • Forgot Your Password
      • Getting Support PIN
    • Support Login
    • Search for Objects
  • Videos
    • Bridge Videos
      • Build Your First App
      • Recorded Training
      • Customize Your Apps
      • Advanced Topics
      • Full App Implementation
      • Tips and Tricks
    • Flex Videos
      • Build Your First App
      • Recorded Training
  • Resources and Best Practices
    • Frequently Asked Questions (FAQ)
    • Tech Tips
    • Troubleshooting
      • Troubleshooting SMS Delivery
      • Troubleshooting Email Delivery and Domain Verification
      • Cannot Log in to My Caspio Account
      • Issue with Login to Apps or DataPages
      • Issue with Redirection After Logout
      • Acknowledgement Emails Are Not Received
      • Issues with Email Verification Code
      • JavaScript Does Not Work with Multiple DataPages
      • Cannot See an SSL Lock Icon for My Web Page
      • Responsive UI Does Not Display Properly
      • Date Fields from Excel Import Incorrectly
      • Troubleshooting Custom PDF Generator
      • Troubleshooting Data Import Speed
      • System Limitations
      • Errors and Messages
    • System Requirements
    • Deprecations
      • Deprecation of Twitter as an ID Service in Authentications and Connections
      • Deprecation of Google Drive for Data Import/Export Tasks
      • Deprecation of HTTP Deployment
      • Deprecation of the Option to Disable AJAX Loading
      • Deprecation of MS Access for Import/Export
      • Deprecation of Cb_ErrorLog Tables
      • Deprecation of Google Map Mashup Generator
      • Deprecation of Frame Deployment
      • Deprecation of .xls Excel Format for Data Import
      • Deprecation of SEO Deployment Method
      • Deprecation of WordPress Deployment
      • Deprecation of Unverified Email Addresses
      • Deprecation of SOAP Web Service
      • Deprecation of Internet Explorer 11 and Microsoft Edge Legacy Browsers
  • Release Notes
    • Impacted Areas 61.0
    • Caspio 60.0
    • Caspio 59.0
    • Caspio 58.0
    • Caspio 57.0
    • Caspio 56.0
    • Caspio 55.0
    • Caspio 54.0
    • Introducing Flex
    • Caspio 53.0
    • Caspio 52.0
    • Caspio 51.0
    • Caspio 50.0
    • Caspio 49.0
    • Caspio 48.0
    • Caspio 47.0
    • Caspio 46.0
    • Caspio 45.0
    • Caspio 44.0
    • Caspio 43.0
    • Caspio 42.0
      • Known Issue: Scrolling on macOS Devices
    • Caspio 41.0
    • Caspio 40.0
    • Caspio 39.0
    • Caspio 38.0
    • Caspio 37.0
      • Impacted Areas 37.0
    • Caspio 36.0
    • Caspio 35.0
    • Caspio 34.0
      • Impacted Areas 34.0
    • Caspio 33.0
    • Caspio 32.0
    • Caspio 31.0
      • Impacted Areas 31.0
    • Caspio 30.0
    • Caspio 29.0
    • Caspio 28.0
    • Caspio 27.0
    • Caspio 26.0
    • Caspio 25.0
    • Caspio 24.0
    • Caspio 23.0
    • Caspio 22.0
    • Caspio 21.5
    • Caspio 21.0
      • Impacted Areas 21.0
    • Caspio 20.0
    • Caspio 19.0
      • Impacted Areas 19.0
      • Security Patch 19.5
    • Caspio 18.0
    • Caspio 17.0
    • Caspio 16.0
    • Caspio 14.0
      • Impacted Areas 14.0
    • Caspio 15.0
    • Caspio 13.0
      • Caspio 13.0
      • Impacted Areas 13.0
    • Caspio 12.0
      • Impacted Areas 12.0
    • Caspio 11.0
      • Impacted Areas 11.0
    • Caspio 10.0
    • Caspio 9.9
      • Impacted Areas 9.9
    • Caspio 9.8
    • Caspio 9.7
    • Caspio 9.6
      • Impacted Areas 9.6
    • Caspio 9.5
      • Impacted Areas 9.5
    • Caspio 9.4
      • Impacted Areas 9.4
    • Caspio 9.3
      • Impacted Areas 9.3
      • Caspio 9.3
    • Caspio 9.2
      • Impacted Areas 9.2
    • Caspio 9.1
      • Impacted Areas 9.1
    • Caspio 9.0
      • Known Issues 9.0
      • Impacted Areas 9.0

Creating and Configuring Charts

24 minutes to read

Learn how to add and set up charts in your AppPages to make complex data easier to compare and interpret.

Steps to create a chart  

  1. In the upper panel, select the Add elements button.  
  2. In the Charts section, select the type of chart that you want to add.
    If you later decide to change the type of your chart, you can always do it from the right panel.   
  3. Select the data source and fields that you want to show on the chart: 
    1. In the Data source panel, select a table or view that will be the primary data source for your DataPart. 
    2. From the Available fields panel, select the fields you want to use in your chart. To do that, click the field or drag it into the Selected fields section.
      Select two fields for Pie Charts and two or more for other chart types.

Note: Smart logic will distribute the selected fields automatically among settings properties (the x-axis and y-axis) of your chart. You can change the default field distribution in the DataPart settings panel. Learn more.

The following image shows the Select fields dialog box for a sample Column Chart:

Sample view showing the available tables and views as well as the fields to add to a column chart

  1. Click Save.

Note: You can restrict the visibility of specific records in a chart by managing roles. Learn more.

After creating a Chart DataPart, you can modify it further by applying additional configuration in the right panel: 

DataPart configuration

Data filters

Settings

Display

Sorting options

DataPart configuration   

Select the Change data source button to choose a different table or view to source the data for this chart.  

Note: All chart settings will be lost if you choose another data source and save the changes.  

Data filters

Select Set filters to set up criteria for DataPart filtering. Learn more.

Settings  

Fields selected from a data source are distributed among different sections depending on the chart type. For Bar, Column, Area, Line and Combination Chart you can distribute the fields among X-axis, Series, and Y-axis, and for a Pie Chart among Category and Value sections. The arrangement of fields in these sections forms the look of your chart. 

See the settings configuration for each chart type below:

Area Chart
Bar Chart
Column Chart
Combination Chart
Line Chart
Pie Chart
Area Chart

For Area Chart, you can distribute the fields among X-axis, Series, and Y-axis.

X-axis

The x-axis is a horizontal axis that contains the name or label for your data points. It is used to categorize the values on a chart. 

  1. Click the Settings  button to modify the axis:
    1. In the Axis title field, enter a name for the axis.
    2. For the Axis labels orientation setting, select how you want to display the category labels on this axis. You can select Auto, Horizontal, or Vertical orientation. For the Auto option, labels might be shown at an angle if needed.
    3. Enter the maximum number of characters for category labels.   
    4. Click Save.
  1. Add a field to the axis by clicking the Add button above the section. 

    Note: You can insert only one field for the x-axis. Without inserting any field for the x-axis, your configuration is incomplete.

  2. For the Date/Time data type fields, choose how you want to group the data based on specific date, time, or period:
      1. Select the field.
      2. In the Field settings pane, in the Data grouping list, select the type of grouping you want to use, and then click Save.

    For example, by grouping data by month, you can effectively summarize daily sales figures into monthly totals for easier interpretation of long-term trends.

Series 

Series group data points from your chart by unique categories taken from the added data source field.  

To add a field to Series, click the Add button located above the section.

Note: 

  • When the fields are added to the Series section, only one aggregation field can be used for the y-axis.
  • You can insert only one field in the Series section.
  • If you use a series, you can only have one y-axis. If you add a series to a chart with more than one y-axis, the additional y-axes will be removed.

Y-axis 

The vertical y-axis aggregates the values from a cross-section of the x-axis and series fields to present them on a chart. 

  1. Click the Settings  button to modify the axis:
    1. In the Axis title field, enter a name for the axis. You can use basic HTML tags to include custom styling.
    2. For the Axis range setting, select how many values you want to display:
      • To automatically scale the range to show all aggregated values, select Auto. 
      • To scale the range in a nonlinear mode, select Logarithmic.
        As a result, the distance between two values on the axis will grow exponentially as the values increase. This option is useful when the data has a wide range of values. 
      • To show a specific range of values, select Fixed, and then enter the values for the start and end of the range. 
    1. For the Axis position setting, specify if you want to position the axis on the left or right of a chart.
    2. For the Axis labels orientation setting, select how you want to display the category labels on this axis – horizontally or vertically.
    3. Click Save.
  1. Add a field to the axis by clicking the Add button above the section. You can insert multiple fields for the y-axis given that the Series section is empty. After adding a field to the y-axis, you can apply additional settings. Select a field added to the y-axis to see the configuration panel.
    1. In Label, specify the label for a line series.

      Note: If a series is used, labels are taken from the data source field added to the Series section.

    2. In the Function section, select the function that should be applied to the aggregate data points based on a table field. The following functions are available:
      • Count – Supports all data types, except Yes/No.
      • Count non-blank – Counts only records that contain values. It applies to Text(255), Number, Integer, Currency, Yes/No, Date/Time, Timestamp, and Formula (depending on a formula) data types.
      • Count checkbox selected – Counts the total number of selected checkboxes. It applies to Yes/No data types.
      • Count checkbox empty – Counts the total number of cleared checkboxes. It applies to the Yes/No data type.
      • Sum – Returns the sum of a set of numbers. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
      • Average – Counts average value from records. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
      • Max/Min – Gets the maximum or minimum value from records. It applies to Text(255), Number, Integer, Currency, Date/Time, Timestamp, and Formula (depending on a formula) data types.
      • None – Shows all numeric values individually without aggregation. It applies to Number, Integer, and Currency data types.
  2. Optional: If you want to configure more y-axes, click Add y-axis, and then repeat steps 1 to 2.

    Note: If you use a series, you can only have one y-axis. If you add more than one y-axis, your series configuration will be removed.

Bar Chart

For Bar Chart, you can distribute the fields among Y-axis, Series, and X-axis.

Y-axis 

The vertical y-axis aggregates the values from a cross-section of the x-axis and series fields to present them on a chart. 

  1. Click the Settings button to modify the axis:
    1. In the Axis title field, enter a name for the axis. You can use basic HTML tags to include custom styling.
    2. For the Axis labels orientation setting, select how you want to display the category labels on this axis. You can select Auto, Horizontal, or Vertical orientation. For the Auto option, labels might be shown at an angle if needed.
    3. Enter the maximum number of characters for category labels.   
    4. Click Save.
  1. Add a field to the axis by clicking the Add button above the section. 

    Note: You can insert only one field for the y-axis. Without inserting any field for the x-axis, your configuration is incomplete.

  2. For the Date/Time data type fields, choose how you want to group the data based on specific date, time, or period:
      1. Select the field.
      2. In the Field settings pane, in the Data grouping list, select the type of grouping you want to use, and then click Save.

    For example, by grouping data by month, you can effectively summarize daily sales figures into monthly totals for easier interpretation of long-term trends.

Series 

Series group data points from your chart by unique categories taken from the added data source field.  

To add a field to Series, click the Add button located above the section. 

Note: 

  • When the fields are added to the Series section, only one aggregation field can be used for the x-axis.
  • You can insert only one field in the Series section.
  • If you use a series, you can only have one x-axis. If you add a series to a chart with more than one x-axis, the additional x-axes will be removed.

You can insert only one field in the Series section.

X-axis

The x-axis is a horizontal axis that contains the name or label for your data points. It is used to categorize the values on a chart. 

  1. Click the Settings  button to modify the axis:
    1. In the Axis title field, enter a name for the axis.
    2. For the Axis range setting, select how many values you want to display:
      • To automatically scale the range to show all aggregated values, select Auto. 
      • To scale the range in a nonlinear mode, select Logarithmic.
        As a result, the distance between two values on the axis will grow exponentially as the values increase. This option is useful when the data has a wide range of values. 
      • To show a specific range of values, select Fixed, and then enter the values for the start and end of the range. 
    3. For the Axis position setting, specify if you want to position the axis on the bottom or top of a chart.
    4. For the Axis labels orientation setting, select how you want to display the category labels on this axis – horizontally or vertically.
    5. Click Save.
  1. Add a field to the axis by clicking the Add button above the section. You can insert multiple fields for the x-axis given that the Series section is empty. After adding a field to the x-axis, you can apply additional settings. Select a field added to the x-axis to see the configuration panel.
    1. In Label, specify the label for a line series.

      Note: If a series is used, labels are taken from the data source field added to the Series section.

    2. In the Function section, select the function that should be applied to the aggregate data points based on a table field. The following functions are available:
      • Count – Supports all data types, except Yes/No.
      • Count non-blank – Counts only records that contain values. It applies to Text(255), Number, Integer, Currency, Yes/No, Date/Time, Timestamp, and Formula (depending on a formula) data types.
      • Count checkbox selected – Counts the total number of selected checkboxes. It applies to Yes/No data types.
      • Count checkbox empty – Counts the total number of cleared checkboxes. It applies to the Yes/No data type.
      • Sum – Returns the sum of a set of numbers. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
      • Average – Counts average value from records. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
      • Max/Min – Gets the maximum or minimum value from records. It applies to Text(255), Number, Integer, Currency, Date/Time, Timestamp, and Formula (depending on a formula) data types.
      • None – Shows all numeric values individually without aggregation. It applies to Number, Integer, and Currency data types.
  2. Optional: If you want to configure more x-axes, click Add x-axis, and then repeat steps 1 to 2.

    Note: If you use a series, you can only have one x-axis. If you add more than one x-axis, your series configuration will be removed.

Column Chart

For Column Chart, you can distribute the fields among X-axis, Series, and Y-axis.

X-axis

The x-axis is a horizontal axis that contains the name or label for your data points. It is used to categorize the values on a chart. 

  1. Click the Settings  button to modify the axis:
    1. In the Axis title field, enter a name for the axis.
    2. For the Axis labels orientation setting, select how you want to display the category labels on this axis. You can select Auto, Horizontal, or Vertical orientation. For the Auto option, labels might be shown at an angle if needed.
    3. Enter the maximum number of characters for category labels.   
    4. Click Save.
  2. Add a field to the axis by clicking the Add button above the section. 

    Note: You can insert only one field for the x-axis. Without inserting any field for the x-axis, your configuration is incomplete.

  3. For the Date/Time data type fields, choose how you want to group the data based on specific date, time, or period:
      1. Select the field.
      2. In the Field settings pane, in the Data grouping list, select the type of grouping you want to use, and then click Save.

    For example, by grouping data by month, you can effectively summarize daily sales figures into monthly totals for easier interpretation of long-term trends. 

Series 

Series group data points from your chart by unique categories taken from the added data source field.  

To add a field to Series, click the Add button located above the section. 

Note: 

  • When the fields are added to the Series section, only one aggregation field can be used for the y-axis.
  • You can insert only one field in the Series section.
  • If you use a series, you can only have one y-axis. If you add a series to a chart with more than one y-axis, the additional y-axes will be removed.

Y-axis 

The vertical y-axis aggregates the values from a cross-section of the x-axis and series fields to present them on a chart. 

  1. Click the Settings  button to modify the axis:
    1. In the Axis title field, enter a name for the axis. You can use basic HTML tags to include custom styling.
    2. For the Axis range setting, select how many values you want to display:
      • To automatically scale the range to show all aggregated values, select Auto. 
      • To scale the range in a nonlinear mode, select Logarithmic.
        As a result, the distance between two values on the axis will grow exponentially as the values increase. This option is useful when the data has a wide range of values. 
      • To show a specific range of values, select Fixed, and then enter the values for the start and end of the range. 
    1. For the Axis position setting, specify if you want to position the axis on the left or right of a chart.
    2. For the Axis labels orientation setting, select how you want to display the category labels on this axis – horizontally or vertically.
    3. Click Save.
  1. Add a field to the axis by clicking the Add button above the section. You can insert multiple fields for the y-axis given that the Series section is empty. After adding a field to the y-axis, you can apply additional settings. Select a field added to the y-axis to see the configuration panel.
    1. In Label, specify the label for a line series.

      Note: If a series is used, labels are taken from the data source field added to the Series section.

    2. In the Function section, select the function that should be applied to the aggregate data points based on a table field. The following functions are available:
      • Count – Supports all data types, except Yes/No.
      • Count non-blank – Counts only records that contain values. It applies to Text(255), Number, Integer, Currency, Yes/No, Date/Time, Timestamp, and Formula (depending on a formula) data types.
      • Count checkbox selected – Counts the total number of selected checkboxes. It applies to Yes/No data types.
      • Count checkbox empty – Counts the total number of cleared checkboxes. It applies to the Yes/No data type.
      • Sum – Returns the sum of a set of numbers. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
      • Average – Counts average value from records. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
      • Max/Min – Gets the maximum or minimum value from records. It applies to Text(255), Number, Integer, Currency, Date/Time, Timestamp, and Formula (depending on a formula) data types.
      • None – Shows all numeric values individually without aggregation. It applies to Number, Integer, and Currency data types.
  2. Optional: If you want to configure more y-axes, click Add y-axis, and then repeat steps 1 to 2.

    Note: If you use a series, you can only have one y-axis. If you add more than one y-axis, your series configuration will be removed.

Combination Chart

For Combination Chart, you can distribute the fields among X-axis and Y-axis.

X-axis

The x-axis is a horizontal axis that contains the name or label for your data points. It is used to categorize the values on a chart. 

  1. Click the Settings  button to modify the axis:
    1. In the Axis title field, enter a name for the axis.
    2. For the Axis labels orientation setting, select how you want to display the category labels on this axis. You can select Auto, Horizontal, or Vertical orientation. For the Auto option, labels might be shown at an angle if needed.
    3. Enter the maximum number of characters for category labels.   
    4. Click Save.
  1. Add a field to the axis by clicking the Add button above the section. 

    Note: You can insert only one field for the x-axis. Without inserting any field for the x-axis, your configuration is incomplete.

  2. For the Date/Time data type fields, choose how you want to group the data based on specific date, time, or period:
      1. Select the field.
      2. In the Field settings pane, in the Data grouping list, select the type of grouping you want to use, and then click Save.

    For example, by grouping data by month, you can effectively summarize daily sales figures into monthly totals for easier interpretation of long-term trends. 

Y-axis 

The y-axis is as a reference for the quantitative data points of data series taken from the x-axis.

  1. Click the Settings  button to modify the axis:
    1. In the Axis title field, enter a name for the axis. You can use basic HTML tags to include custom styling.
    2. For the Axis range setting, select how many values you want to display:
      • To automatically scale the range to show all aggregated values, select Auto. 
      • To scale the range in a nonlinear mode, select Logarithmic.
        As a result, the distance between two values on the axis will grow exponentially as the values increase. This option is useful when the data has a wide range of values. 
      • To show a specific range of values, select Fixed, and then enter the values for the start and end of the range. 
    1. For the Axis position setting, specify if you want to position the axis on the left or right of a chart.
    2. For the Axis labels orientation setting, select how you want to display the category labels on this axis – horizontally or vertically.
    3. Click Save.
  1. Add a field to the axis by clicking the Add button above the section. After adding a field to the y-axis, you can apply additional settings. Select a field added to the y-axis to see the configuration panel.
    1. In Label, specify the label for a line series.
    2. In the Function section, select the function that should be applied to the aggregate data points based on a table field. The following functions are available:
      • Count – Supports all data types, except Yes/No.
      • Count non-blank – Counts only records that contain values. It applies to Text(255), Number, Integer, Currency, Yes/No, Date/Time, Timestamp, and Formula (depending on a formula) data types.
      • Count checkbox selected – Counts the total number of selected checkboxes. It applies to Yes/No data types.
      • Count checkbox empty – Counts the total number of cleared checkboxes. It applies to the Yes/No data type.
      • Sum – Returns the sum of a set of numbers. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
      • Average – Counts average value from records. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
      • Max/Min – Gets the maximum or minimum value from records. It applies to Text(255), Number, Integer, Currency, Date/Time, Timestamp, and Formula (depending on a formula) data types.
      • None – Shows all numeric values individually without aggregation. It applies to Number, Integer, and Currency data types.
  2. Optional: If you want to configure more y-axes, click Add y-axis, and then repeat steps 1 to 2.
Line Chart

For Line Chart, you can distribute the fields among X-axis, Series, and Y-axis.

X-axis

The x-axis is a horizontal axis that contains the name or label for your data points. It is used to categorize the values on a chart. 

  1. Click the Settings  button to modify the axis:
    1. In the Axis title field, enter a name for the axis.
    2. For the Axis labels orientation setting, select how you want to display the category labels on this axis. You can select Auto, Horizontal, or Vertical orientation. For the Auto option, labels might be shown at an angle if needed.
    3. Enter the maximum number of characters for category labels.   
    4. Click Save.
  1. Add a field to the axis by clicking the Add button above the section. 

    Note: You can insert only one field for the x-axis. Without inserting any field for the x-axis, your configuration is incomplete.

  2. For the Date/Time data type fields, choose how you want to group the data based on specific date, time, or period:
      1. Select the field.
      2. In the Field settings pane, in the Data grouping list, select the type of grouping you want to use, and then click Save.

    For example, by grouping data by month, you can effectively summarize daily sales figures into monthly totals for easier interpretation of long-term trends. 

Series 

Series group data points from your chart by unique categories taken from the added data source field.  

To add a field to Series, click the Add button located above the section. 

Note: 

  • When the fields are added to the Series section, only one aggregation field can be used for the y-axis.
  • You can insert only one field in the Series section.
  • If you use a series, you can only have one y-axis. If you add a series to a chart with more than one y-axis, the additional y-axes will be removed.

Y-axis 

The vertical y-axis aggregates the values from a cross-section of the x-axis and series fields to present them on a chart. 

  1. Click the Settings  button to modify the axis:
    1. In the Axis title field, enter a name for the axis. You can use basic HTML tags to include custom styling.
    2. For the Axis range setting, select how many values you want to display:
      • To automatically scale the range to show all aggregated values, select Auto. 
      • To scale the range in a nonlinear mode, select Logarithmic.
        As a result, the distance between two values on the axis will grow exponentially as the values increase. This option is useful when the data has a wide range of values. 
      • To show a specific range of values, select Fixed, and then enter the values for the start and end of the range. 
    1. For the Axis position setting, specify if you want to position the axis on the left or right of a chart.
    2. For the Axis labels orientation setting, select how you want to display the category labels on this axis – horizontally or vertically.
    3. Click Save.
  1. Add a field to the axis by clicking the Add button above the section. You can insert multiple fields for the y-axis given that the Series section is empty. After adding a field to the y-axis, you can apply additional settings. Select a field added to the y-axis to see the configuration panel.
    1. In Label, specify the label for a line series.

      Note: If a series is used, labels are taken from the data source field added to the Series section.

    2. In the Function section, select the function that should be applied to the aggregate data points based on a table field. The following functions are available:
      • Count – Supports all data types, except Yes/No.
      • Count non-blank – Counts only records that contain values. It applies to Text(255), Number, Integer, Currency, Yes/No, Date/Time, Timestamp, and Formula (depending on a formula) data types.
      • Count checkbox selected – Counts the total number of selected checkboxes. It applies to Yes/No data types.
      • Count checkbox empty – Counts the total number of cleared checkboxes. It applies to the Yes/No data type.
      • Sum – Returns the sum of a set of numbers. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
      • Average – Counts average value from records. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
      • Max/Min – Gets the maximum or minimum value from records. It applies to Text(255), Number, Integer, Currency, Date/Time, Timestamp, and Formula (depending on a formula) data types.
      • None – Shows all numeric values individually without aggregation. It applies to Number, Integer, and Currency data types.
  2. Optional: If you want to configure more y-axes, click Add y-axis, and then repeat steps 1 to 2.

    Note: If you use a series, you can only have one y-axis. If you add more than one y-axis, your series configuration will be removed.

Pie Chart

For Pie Chart, you can distribute the fields among Category and Value sections.

Category

The Category section categorizes the data points into groups.

  1. To add a field to Category, click the Add button located above the section.
  2. For the Date/Time data type fields, choose how you want to group the data based on specific date, time, or period:
      1. Select the field.
      2. In the Field settings pane, in the Data grouping list, select the type of grouping you want to use, and then click Save.

    For example, by grouping data by month, you can effectively summarize daily sales figures into monthly totals for easier interpretation of long-term trends.

Value

Value shows a proportional representation associated with each category on the chart in percentage terms.

To add a field to Value, click the Add button located above the section.

In the Function section, select the function that should be applied to the aggregate data points based on a table field. The following functions are available:

  • Count – Supports all data types, except Yes/No.
  • Count non-blank – Counts only records that contain values. It applies to Text(255), Number, Integer, Currency, Yes/No, Date/Time, Timestamp, and Formula (depending on a formula) data types.
  • Count checkbox selected – Counts the total number of selected checkboxes. It applies to Yes/No data types.
  • Count checkbox empty – Counts the total number of cleared checkboxes. It applies to the Yes/No data type.
  • Sum – Returns the sum of a set of numbers. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
  • Average – Counts average value from records. It applies to Number, Integer, Currency, and Formula (depending on a formula) data types.
  • Max/Min – Gets the maximum or minimum value from records. It applies to Text(255), Number, Integer, Currency, Date/Time, Timestamp, and Formula (depending on a formula) data types.
  • None – Shows all numeric values individually without aggregation. It applies to Number, Integer, and Currency data types.

Display

Use the Show legend toggle to hide and show the chart legend as required.

Sorting options

Select how you want to sort the chart data by default and how the app users can change it.

  1. Optional: If you want to sort the chart data by default based on field data, in the Default sorting section, select By field, and then add and arrange the sorting fields.
  2. Optional: If you want to display a dropdown list with sorting options next to the chart, turn on the Sort via dropdown switch, and then arrange the options that you want to display in the dropdown.
  • PRODUCT

  • Platform Overview
  • Why Low Code
  • Case Studies
  • App Marketplace
  • Pricing
  • Get a Custom Demo
  • Free Trial
  • SOLUTIONS

  • Healthcare
  • Education
  • Government
  • Financial Services
  • Energy and Utilities
  • Nonprofits
  • Media
  • Consulting
  • RESOURCES

  • Resource Center
  • Blog
  • Free Training
  • Online Help
  • Onboarding
  • Get Certified
  • Professional Services
  • Support Center
  • COMPANY

  • Our Story
  • Careers
  • Leadership
  • News
  • Partner Programs
  • Referral Program
  • Academic Program
  • Discount Programs
  • Contact Us
  • TRENDING

  • Build Custom CRM
  • Create Web Dashboards
  • Best Online Database
  • Convert Excel to Web
  • Migrate MS Access Online
  • HIPAA Compliant Database
  • Create a Patient Portal
Caspio Logo

Caspio is the world’s leading cloud platform for building online database applications without coding.
Start a free trial today and experience the power of no-code.

Footer Partners

© 2025 Caspio, Inc. Sunnyvale, California. All rights reserved.

  • Privacy Statement
  • Terms of Use
  • Report Abuse
  • Feedback