Forum Discussion

nkp's avatar
nkp
Copper Contributor
Jan 08, 2026

How to create a multi-tiered percentage-based bar chart?

Hello, I would like to create a multi-tiered percentage-based bar chart based on the data found below (test data evidently). Column B and C add up to 100%, Column D and E add up to 100%, and lastly ...
BI & Data Analysis
Charting
community
excel
office 365
training
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jan 10, 2026

The essential characteristic of the replies you have received is that the data needs to be unpivoted in order to plot it.  This can be done using PowerQuery or by formula.

= LET(
    wrapped, WRAPROWS(TOCOL(data),2)/100,
    name,    TAKE(WRAPROWS(TOCOL(IF(data, Tabelle1[Employee])),2),,1),
    hdr,     TAKE(WRAPROWS(TOCOL(IF(data, header)),2),,1),
    HSTACK(name, hdr, wrapped)
  )

If you include the attribute names in the chart data then the presentation can be labelled more meaningfully.

 

 

Resources