Radar Chart - custom source data labels

[andyb123]

Hi,


I've created a range of radar charts to display data. Since I am unable to make the axis different for each data point, I have indexed all the values as percentages of values.

Lets say the original data points are in cells A1:A6

The indexed data points are in cells B1:B6

The radar chart is using the data in cells B1:B6 but I would like to display data labels from cells A1:A6.

Is there a way to do this? I have seen a video that suggested I can select data from a custom source, but I am unable to find it. I'm using Office for Mac 2011 14.6.8.


Thanks

 

[ISY]

Hi

Link: https://sites.google.com/site/e90e50fx/home/infographic-chart-with-excel