I rarely use charts but now it would be useful to make it from a column with just text values. For instance in a column I have: 5 times "reason1", 3 times "reason2", 2 times "reason 3" etc (might be blanks too)
Now I want simply a percentage pie chart with the actual value as a category name.
I can make a row with those category names (reasons) and use "countif" below to make it up in numbers but perhaps there is an easier way ?
Bookmarks