How do I choose what to be displayed as legend in a pie chart?

I have a column with type ref (“column 1”) and a column with numbers (“column 2”)
When I create a pie chart returns the row I believe of the referred data rather the actual name
EXAMPLE
Row Fruit. Spent
1 Apple. 10
2 Banana. 20
3 Orange. 10
Instead of Banana = 50% returns “2”=50% which I believe is the row.
How can I set the legend to say Banana instead of 2

Change the Label column in your Table.

3 Likes

I did and did not work
the solution actually was to remove the row numbers column