Hello!
I have a pivot table shown below that I am having trouble with.
What I essentially want to do is make a radar graph that counts the % of Yes for each "title."
One challenge is having the pivot table ignore the other answers, which are "blank" and "no."
The graph on the left is what I'd like it to do, but by using a pivot table I would be able to sort it by month.
I've tried my best on the right graph, but I am unable to figure it out. If anyone can guide me to the right answer I would be greatful.
If you have any other questions please let me know. Thanks!
http://s000.tinyupload.com/index.php...18037610590251
Bookmarks