Hopefully, the attached image will clearly demonstrate my issue.
I need to create radar charts. The charts have four active and four in-active axis. The two in-active axis are the vertical and horizontal axis. I have been able to get the chart to connect all the lines of the graph to connect across the in-active (nil value) axis - except for the top one.
The top axis is and must remain labelled 'Flexibility'. I have been using the #N/A formula to connect the lines of the graph across all the other 3 in-active axis. Why won't it go across the 4th?
Bookmarks