Here is my idea of graphic presentation in such case:
Prepare dummy series of data with triplets of pairs of coordinates
1) some central point
2) point at offset xdiff and ydiff from this central point
3) pair of #NA! errors
and next triplet but for second pair of xdiff, ydiff (for second column)
4) some central point (i used one moved to right at constant distance
5) point at offset xdiff and ydiff from this central point
6) pair of #NA! errors
and so on
such a formula could be used to find such triplets (see column I in attachment)
for column J almost the same (I just skipped moving right)
well, I truncated formula even more to have labels for each triplet (column K)
After making scatterplot (but no point markers, only interconnecting lines) and playing with it's size and axes it looks pretty nice to me
I made also second approach which is closer to polar plot idea - it's in the copy of original sheet
The only thing changed is formula in K. It now locates description near the offseted point
And of course I played a bit with graph size and axes again
See the screenshot and the file.
Bookmarks