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

Another Power Query option that makes the chart more readable:

File (to download) available at:
https://1drv.ms/x/c/1cd824d35610aacb/IQAdKE5z--lsR4BVrh7bA833AfxBO6fTeCWY3ogM3-mTAvc?e=KuP6fe

EDIT: Trying to attach file...

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.

Hi,

In cell I2 I have applied this formula:

=HSTACK(TEXTSPLIT(TEXTJOIN("",, REPT(A2:A5 & ",", COLUMNS(B2:G5) / 2)),, ",", TRUE), WRAPROWS(TOCOL(B2:G5), 2))

I then selected cells I2:K13 and in the Insert Chart window I chose Bar (see the screenshot above).

Hope this helps.

IlirU

Hi

A 365 dynamic option. With your data formatted as table named Table1 in the below formula:

=LET(
  data,         Table1,
  colsCount,    COLUMNS( data ),
  fieldsCount,  colsCount -1,
  names,        TOCOL( IF( SEQUENCE(, fieldsCount/2), CHOOSECOLS(data, 1) ) ),
  values,       WRAPROWS( TOCOL( CHOOSECOLS(data, SEQUENCE(fieldsCount,,2) ) ), 2 ),
  VSTACK(
    {"Employee name", "value 1", "value 2"},
    HSTACK( names, values )
  )
)

I've applied Power Query to convert the blue table into the green result table. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table. The stacked bar chart is updated dynamically.