Illuminate BI Tool Guide
  • Introduction
  • Example BI Reports
  • What is BI Reporting in Illuminate?
  • Getting Started Using BI with Custom Reports
    • Setup Jaspersoft Studio
    • Prepare Your Data Set
    • Create a Basic Jasper Report
    • Publish My Report to Illuminate
    • Edit Report After Publishing
    • Display Selected Filters on Your Report
  • Get Started Using BI with SQL
    • Access Data Via ODBC Connection
    • Learn the Schema
    • Setup Jaspersoft Studio for SQL
    • Create a Basic Report with SQL
    • Publish My Report (SQL Method)
    • Adding Input Controls
  • Tutorials
    • Tutorials for Free Version ("Community Edition")
      • Tutorial 1: Categorize and Aggregate Your Data
      • Tutorial 2: Using Jasper Report Bands
      • Tutorial 3: Student Roster Report
      • Tutorial 4: Student Roster with SQL
      • Tutorial 5: Summary of Performance
      • Tutorial 6: CELDT Longitudinal Summary
    • Tutorials for Pro Version ("Professional Edition")
      • Tutorial 1: Aggregate and Visualize Your Data
        • Step 1 - Create a Custom Report
        • Step 2 - Download Your Data
        • Step 3 - Create a Data Adapter
        • Step 4 - Duplicate Template. Link Data Adapter
        • Step 5 - Set Class for Numeric Fields
        • Step 6 - Add & Configure Chart
        • Step 7 - Resize Chart. Preview Report.
        • Step 8 - Change Chart Labels
        • Step 9 - Set Chart Colors
        • Step 10 - Repeat for Other Data Points
        • Step 11- Install Your Report
      • Tutorial 2: Using Report Bands
        • Step 1 - Duplicate Report from Tutorial 1
        • Step 2: Create Your Group
        • Step 3: Create a Sort Field
        • Step 4 - Copy & Paste Your Chart
        • Step 5 - Set Reset Type and Evaluation Time
        • Step 6 - Change the Category Level
        • Step 7 - Add Site Name Field
        • Step 8 - Grade Level Sorting
    • CrossTabs Tutorial - Create, Format, and Style a CrossTab
      • Step 1 - Create Your CrossTab
      • Step 2 - Size and Position Your CrossTab
      • Step 3 - Format and Style Your CrossTab
  • Homework 1 - BI Workshop Follow Up
  • BI Tool Cheat Sheet
  • JasperSoft Studio Tips, Tricks, & FAQs
    • Basics of Writing Expressions in JSS
    • Rounding Decimals
    • Working with Dates in JSS
    • Conditional Styling in JasperSoft
    • Custom "No Data" Message
    • Create Multiple Summary Bands
    • Create Hyperlinks or "Tabs" to Connect Sets of Reports
    • JSS Community Edition
      • Adding Data Labels to Your Chart
      • Customizing Colors in Your Charts
    • JSS Professional Edition Only
      • HTML5 Charts
        • Data Labels: Enable, Customize, & Round Data Labels
        • Tooltip: Customizing the Tooltip
        • Keeping Colors Consistent in HTML5 Charts
        • Adding Drill Down to a Chart
        • Prevent Tooltip from Being Cut Off
        • Sort the Bars in Your Stack - Ordering the Series in Your Chart
        • Passing Parameters/Data Between Datasets with HTML5 Charts
        • Add Plot Lines to your Chart
        • Add Colored Zones or Plot Bands to Your Chart
        • Change Bar Colors Based on Bar Value
    • Rolling Over Your BI Tool Reports
    • "Current" Columns in Custom Reporting - To Use or Not to Use?
  • Report Design Best Practices
  • Installing the Illuminate Font Set
  • Report Templates
    • Blank Templates - Report Starters
    • Using the Report Templates
    • Multiple Measures Site Comparison Report (Tutorial 5)
    • EL Reclassification Report
    • EL Reclassification Report v2
    • RFEP Monitoring Report
    • Student Rubric Template
    • Michigan Report Templates
      • PSAT and SAT College Readiness Report
  • BI Tool User Community
Powered by GitBook
On this page
  • How to Enable, Customize, & Round Data Labels
  • Enable Data Labels
  • 1. Navigate to Advanced Properties
  • 2. Add Property
  • Where did I get the property name and value?
  • Customize Your Data Labels
  • Display the Percentage Instead of the Count
  • Round Your Data Labels

Was this helpful?

  1. JasperSoft Studio Tips, Tricks, & FAQs
  2. JSS Professional Edition Only
  3. HTML5 Charts

Data Labels: Enable, Customize, & Round Data Labels

PreviousHTML5 ChartsNextTooltip: Customizing the Tooltip

Last updated 5 years ago

Was this helpful?

How to Enable, Customize, & Round Data Labels

Enable Data Labels

1. Navigate to Advanced Properties

To enable Data Labels in HTML5 charts, you'll need to use the Advanced Properties.

  • Double-click on your chart.

  • Click "Advanced Properties"

2. Add Property

  • Click "Add"

  • Set the Property name to:

    • plotOptions.[CHART TYPE].dataLabels.enabled

      • Examples:

        • plotOptions.bar.dataLabels.enabled

        • plotOptions.column.dataLabels.enabled

        • plotOptions.pie.dataLabels.enabled

  • Check ✅ Use an expression

  • Set the Property value to:

    • "true"

That's it! Your chart will now have data labels.

But wait...

Where did I get the property name and value?

There's a lot of them...which is both the pain and the beauty of the HTML5 charts. They are extremely customizable, but you may have to dig for a while to find the property you're looking for.

Customize Your Data Labels

Display the Percentage Instead of the Count

If you've added data labels to a Stacked Percent chart, you'll notice immediately that the data labels, by default, display the count, not the percentage, of students for each bar. I highly recommend changing this. You will like confuse your user if the data labels do not match what the chart is actually visualizing.

To display the percentage, you'll need to format your data label:

  • Double-click on your chart

  • Go to Show Advanced Properties

  • Click *Add

  • Set the Property name to:

    • plotOptions.[CHART TYPE].dataLabels.format

      • Examples:

        • plotOptions.bar.dataLabels.format

        • plotOptions.column.dataLabels.format

        • plotOptions.pie.dataLabels.format

  • Check ✅ Use an expression

  • Set the Property value to:

    • "{point.percentage:.1f}"

      • {point.percentage} displays the percentage.

      • :.1f rounds the percentage to 1 decimal point (see below for more information about rounding data labels).

        • Note: In a Stacked Percent chart, "{point.y}" will display the raw data (i.e. the count of students), and "{point.percentage}" will display the percentage. If you wanted to display both the count and the percentage, you would set the property value to: "{point.y} Students({point.percentage:.1f}%)" There's typically not enough room for this much information in a data label, so I do not recommend displaying both in most circumstances.

Your data labels should now be showing the percent of students for each bar.

Round Your Data Labels

If you need to round your data labels:

  • Add or Edit the Data Label Format:

    • Click Add (or modify the property if you've already added it)

    • Set the Property name to:

      • plotOptions.[CHART TYPE].dataLabels.format

        • Examples

          • plotOptions.bar.dataLabels.format

          • plotOptions.column.dataLabels.format

          • plotOptions.pie.dataLabels.format

  • Check ✅ Use an expression

  • Set the Property value to:

    • "{point.y:.1f}"

    • Or, "{point.percentage:.1f}" for a Stacked Percent chart

      • The :.1f must be after point.y or point.percentage but inside the curly bracket "}"

      • :.1f will round the label to 1 decimal place

      • :.2f will round the label to 2 decimal places

      • :.0f will round the label to a whole number, and so on.

TIP: Paste the property name into JSS by copying the last section of the URL from the highcharts website to ensure you get the exact name. Click on the property you want, then copy and paste the last part of the URL into the "Property name" field in JSS.

Follow this link to see the full list of customizable HTML5 chart (a.k.a "Highcharts") properties can be found.