Documentation
  • The Fundamental
  • ACTIVE SYNC
    • Data Ingestion
      • Data Tracking
        • API Key Management
        • Generate Tracking ID
        • Install tracking with Tag Manager
        • Install Tracking from the Console
        • Tracking Method on Website
      • Datasource
        • MySQL
        • PostgreSQL
        • MongoDB
        • Microsoft SQL Server
        • Shopify
        • CSV
        • Google Sheets
    • Data Ingestion API
      • Data Lake
        • File upload
        • Tracking API
      • Data Warehouse
        • Batch upload
        • CSV upload
        • Tracking API
      • Data Schema Warehouse API
    • Data Integrations
      • Manage your API Key
      • Get Data using API
  • ROCKET.BI
    • Introduction
    • Data Warehouse
      • Data Management
      • Ad-hoc Query
        • Measure Schema
        • Calculated Field
      • Query Analysis
      • Relationship
    • Row-level Security
    • Dashboard
      • Dashboard Filter
      • Chart Control
        • Tab Control
        • Single Choice
        • Multiple Choice
        • Dropdown Control
        • Slicer Control
        • Date Control
        • Input Control
      • Manage Dashboard
        • Relationship
        • View and Share
        • Select Main Date Filter
        • Boost
        • Settings
        • Add Chart
        • Add Tab
        • Add Text
    • Chart Builder
      • Chart Types
        • Pie Chart
        • Column Chart
        • Bar Chart
        • Line Chart
        • Line Stock Chart
        • Pareto Chart
        • Bubble Chart
        • Scatter Chart
        • Map Chart
        • Area Chart
        • KPI Chart
        • Lollipop Chart
        • Parliament Chart
        • Funnel Chart
        • Pyramid Chart
        • Gauge Chart
        • Bullet Graph Chart
        • Heat Map Chart
        • Word Cloud Chart
        • Tree Map Chart
        • Stacked Column Chart
        • Stacked Bar Chart
        • Sankey Chart
        • Spider Web Chart
        • Wind Rose Chart
        • Histogram Chart
        • Bell Curve Chart
        • Table Chart
        • Pivot Table Chart
      • Chart Settings
        • Zoom
        • Inner chart filter
      • Chart Filters
        • Tab Filter
        • Single Choice
        • Multiple Choice
        • Dropdown Filter
        • Slicer Filter
        • Date Filter
        • Input Filter
      • Right-click Settings
        • Change date function
        • Drill down
        • Drill through
        • Use as a filter
    • SQL Query
      • Syntax
      • Functions
      • Aggregate Functions
      • Data Types
  • UNLOCK.CI
    • Unlock.CI
Powered by GitBook
On this page
  • 1. What is a Line chart?
  • When to use a Line Chart?
  • 2. How to build a Line chart with example
  • 3. Line Chart Config
  1. ROCKET.BI
  2. Chart Builder
  3. Chart Types

Line Chart

Also known as Line Plot, Line Graph

PreviousBar ChartNextLine Stock Chart

Last updated 1 year ago

1. What is a Line chart?

A line chart is a form of graphical representation of data in the form of lines. Depending on the data being investigated, the line may be either straight or curved.

When to use a Line Chart?

A line chart is ideal for the following cases:

  • Display how the data is changing through time. Especially, how much has been changed over a period of time?

  • The number of categorical values in the dimension is over 8

  • Too many data points or columns to plot

2. How to build a Line chart with example

The line chart portrays revenue trends over time, presenting a continuous visual representation of how revenue has evolved or fluctuated across different periods, enabling a comprehensive analysis of the revenue trajectory.

  1. Click Click here to add your first chart

  2. In the menu, select Line to create a line chart

3. Line Chart Config

  1. Select the database you use to create suggested in the list

  2. Choose the table containing the data you use to create, then it will show you the list of fields included in the table

  3. Drag/drop or select the X-Axis value

  4. Drag/drop or select the Y-Axis value

  5. Drag/drop or select the Legend properties (optional)

  6. Drag/drop or select the Sorting field to sort out the data in the chart (optional)

  7. Drag/drop or select the Filters field to emphasize a specific data (optional)

  8. You can see the visualization of your chart on the left side and select Settings to change the element’s settings

  • TITLE & SUBTITLE

You can change the title of the chart, choose the font, color and size of the name. You can also add the subtitle and change its format.

  • DISPLAY

Legend field contains the sub-categories that split each line into multiple lines corresponding to the categories. Each line still represents the same measure. You can change its display name or type (column, line, area, lollipop).

  • LEGEND

You can change the legend position (top, bottom, middle), input the name, choose the font, color and size of the name.

  • X AXIS

When you turn on the X Axis, you can input the Prefix, Postfix and change their format. X Axix title can also be added and change format too.

  • Y AXIS

When you turn on the X Axis, you can input the Prefix, Postfix and change their format. X Axix title can also be added and change format too. If you turn on Gridlines, you can change the size and the display of the Gridlines (solid, dash, dot,...).

  • DATA COLOR

Data color can be set auto or you can choose your favorite colors.

  • DATA LABEL

If you turn the label on, you can choose its style to perform (percent, value, raw), choose the font, color and size of the label and its position.

  • BACKGROUND

You can change the background color of the chart.

  • TOOLTIP

When you hover over a line of the chart, a text box appears to display information about the data of that line. You can change the text color, font, and background.

  • OTHER

Change the display unit, precision, and other functions

9. After building the chart visualization, click Add to create your chart.

10. Your chart will show up along with actions like sharing, editing, etc.

We hope that the above instructions will be useful to you. Let's have a look at our other articles to learn more about using other charts in data visualization with Rocket.BI.