Chart with delimited data

[EduEHESP]

Hello commun ity,
I have a table with a colum that contain item delimited by ";"

Colum A

---------------

Item 1 ; Item 2; item 4

---------------

Item 3 ; Item 4

---------------

Item 1 ; Item 3; item 4

---------------

Item 5

-----------

I  would like to create a bar chart with in axis X every individal Item and in axis Y his number in colum A

     2          1           2           3           1

---------------------------------------------

Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | 

Thank you for helping me

[EduEHESP]

Thank you @ryan_mayu  🙂

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@EduEHESP 

you can split by delimeter in PQ

then create a chart

pls see the attachment below