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 |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |