Cannot get a staked column graph to display what I need.

[Ambs80]

Hi all

A part of my dataset (from excel), I have two columns. One with task ID's and one with weeks open. (see below)
I am trying to show this in at stacked column. For example, 101239 have been open for 261 days and 101428 have been open 195 days. I put task ID's on the Axis, and the weeks open on values, but instead of showing 101239 on the x-axis and 261 on the y-axis, it shows a continuous x- axis and not just showing the task ID's. On the y-axis it shows the count of ID's (for example 101428 displays 5 instead of 195). (See attached picture)
I have tried many things now, but cannot get it to work, does anyone know, what I need to change?

BR,
André

Task ID's 101239 101428 101428 101428 101428 101428 101533 101533 101533 101533 101533 101533 101533 101533 101533 101533 101533 101533 101533 101533 101507 101507 101507 101507 101507 101507 101507 101507 101507 101670 101670 101670 101670 101670 101706 101781 101824 101824 101824 101824 101824 101824 101826 101826 101826 101827 101827 101827 101827 101827 101849 101849 101854 101830 101830 101829 101829 101825 101825 101825 101825 101825 101825 101825 101895 101895 101828 101912 101908 101908 101908 101908 101934 101955 101955 101955 101955 101955 101955 101955 101955 101955 101955 101955 101955 101955 101955 101955 101955 101955 101978 101978 101978 101978 101978 101978

Weeks open 261 195 195 195 195 195 164 164 164 164 164 164 164 164 164 164 164 164 164 164 164 164 164 164 164 164 164 164 164 121 121 121 121 121 107 79 51 51 51 51 51 51 51 51 51 50 50 50 50 50 50 50 45 43 43 34 34 33 33 33 33 33 33 33 33 33 33 26 26 26 26 26 19 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 3 3 3 3 3 3

 

[mart37]

Count of ID's = count of records with the same ID --> 101428 have 5 records(rows) ==> answer=5 (and not 195)
With AVERAGE you get what you want (I think).

 

[Ambs80]

Count of ID's = count of records with the same ID --> 101428 have 5 records(rows) ==> answer=5 (and not 195)
With AVERAGE you get what you want (I think).
View attachment 35204

Super, it was exactly what I needed! Thank you very much