Display data chart from lookup

Hello, I have a problem in displaying the data that I want in the field of a chart : the data basis of the chart is collection “CA’s_select” but it only contains the suppliers id’s, where I would like the supplier’s name.
I already tried with lookup formula but it doesn’t work as I don’t have an “item” tab when choosing what data to include in my formula.
Any thoughts ?