ECharts with dataset

Hello

I’m a bit stuck on using the ECharts view on my data.

I’m trying to recreate the following diagram we have in Excel:

I’m working with the following table, columns go up to 44, I’ve already “pushed” the header down to row 1:

| Column 1   | Column 2 | Column 3 | Column 4 | E  | F  | G  | H  | I  | J  | K  | L   | M  | N  |
| Status     | Past Due | 19       | 20       | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28  | 29 | 30 |
| Planned    | ?        | 25       | 33       | 45 | 40 | 67 | 39 | 47 | 50 | 40 | 101 | 43 | 26 |
| Released   | 47       | 39       | 31       | 24 | 8  | 16 | 11 | 21 | 14 | 12 | ?   | 1  | 3  |
| Unreleased | 2        | 28       | 17       | 27 | 26 | 16 | 7  | 1  | 6  | 3  | 4   | 15 | 0  |

The status column refers to the “category” while the top row is past due or the calendar week.

I will always be the same 3 or 4 rows for the bars.

I could manually set up all the columns but I figured it should be easier to use the dataset option.

I’ve tried the following to no avail:

Thanks in advance