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 Stacked Column chart?
  • When to use Stacked Column Chart?
  • 2. How to build a Stacked Column chart with example
  • 3. Stacked Column Chart Config
  1. ROCKET.BI
  2. Chart Builder
  3. Chart Types

Stacked Column Chart

Also known as Stacked Column Graph

PreviousTree Map ChartNextStacked Bar Chart

Last updated 1 year ago

1. What is a Stacked Column chart?

A stacked column chart shows the composition and comparison between values across categories. It is a form of column chart that is a series of columns stacked vertically, on top of each other. The height of each series is determined by the value of each data point.

When to use Stacked Column Chart?

A stacked column chart is ideal for:

  • Data that is segmented and added to a whole

  • Comparison across the different columns

  • Compare the individual category of one category across the different columns, specifically whichever category is sitting on the axis, or any category where the bottom of its section of the column is in a consistent place across the columns

  • Compare the size of different categories if they're very different

2. How to build a Stacked Column chart with example

The stacked column chart visually represents the sales revenue over time, providing a breakdown by item types through the use of stacked columns, allowing businesses to easily analyze the revenue contribution of each item type across different time periods and identify trends or patterns in the sales performance of individual product categories over time.

  1. Click Click here to add your first chart

  2. In the menu, select Stacked Column to create a Stacked column chart

3. Stacked Column 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 Breakdown value (optional)

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

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

  9. 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

You can change each stacked column's display name.

  • STACK

Stacked columns can be shown in Value or Percentage style. You can also group each stacked column by inputting the number of columns you want to group.

  • 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 stacked column of the chart, a text box appears to display information about the data of that column. You can change the text color, font, and background.

  • OTHER

Change the display unit, precision, and other functions

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

11. 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.