100% Stacked Column Chart

Introduction

Functions

A 100% stacked column chart can be used to represent the percentage of each sub-category values to the total value of that category, with each column adding up to a total of 100%.

Application Scenarios

It is especially useful to showcase the proportion between different sub-categories within different categories.

Basic Requirements

Preview

Setting Procedure

This article will use data imported from Excel to show how to set a 100% stacked column chart.

Importing Data

Visit the authorized app, click and select New Form > Create from Excel.

Then import the Excel data you have prepared. When importing, change the field type to be used in Dimension from Single Line to Radio.

Creating a Dashboard

Go back to the app interface and create a dashboard.

Then rename the dashboard, add a Stats, and tick the form you just created as the data source.

Setting the Chart

In the Stats page, rename the stats, drag and drop fields to Dimension and Measure, and set the chart type as 100% Stacked Column Chart under Column Chart Type.

Chart Color

In Style, you can configure the style of the column chart.

Demonstration

1. On PC

2. On Mobile

Notes

Display All Labels is enabled by default for 100% stacked column chart. The default number of decimal places is set to two and cannot be modified.