Adding Secondary Axes to Radar Charts

[BryceVBA]

Hello all,

I've recently made some radar charts comparing manufactures based on their scorecards. They look good, but I would like to take it a step further and add different weightings to the score categories to give more meaning for mgmt review.

After doing some research, I read that use of multiple scales (axes) are possible with radar charts if you have the right software. (See excerpt from reading in excel attachment)

I'm attempting to create a radar chart with an axis for each category, much like the one from Figure 3 in the reading so that the weightings are identified in the chart and so that the weightings are not disfiguring the chart itself.

Does anyone know if this is possible to do only through Excel 2016, or if I need an additional add-in or extension software to make this possible?

If you do know how to add extra axes to a radar chart, please share.

Thanks,

[Andy Pope]

The only way to create that type of chart is to draw it yourself using xy-scatter.
That means calculating and rescaling all the data points along with some trig formula to get the correct xy positions. Finally you would need to use custom data labels in order to build each axis