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.
I did and did not work
the solution actually was to remove the row numbers column
User | Count |
---|---|
46 | |
29 | |
24 | |
22 | |
13 |