Use linked column selection in chart block


Hi, I have a linked column and would like to use the selected record in a chart block. I have created a resource plan for my team to show what projects they are planning to work on in the future. The base has a date field, and a number field for the hours they plan to work on in the day, and I would like to link to the table with all of the list of projects, however the linked column is not an option you can use within a chart block.

I have also tried using a formula column to convert the linked record into text, and this doesnt work either.

any help would be awesome.