Excel 2021: how to set the "radar" chart to represent five variables of different scales?

[Jamal NUMAN]

Excel 2021: how to set the "radar" chart to represent five variables of different scales?




For example, in the screenshot below, the radar chart to the left represents five variables. Since the ranges of these variables vary, the radar chart currently lacks useful information. Is there a way to still use the radar chart when each variable has a different scale?

[p45cal]

Plot them on a log scale?:


2024-10-30_202331.jpgthen remove the scale…

[Jamal NUMAN]

The radar chart is still not as clear as the bar chart, even with the log transformation.

[p45cal]

Originally Posted by Jamal NUMAN

The radar chart is still not as clear as the bar chart, even with the log transformation.

I agree. You can have a secondary axis in a radar chart but no more than that. I'd venture that a radar chart is not the best way to present these data. BTW, you don't need to have a separate table of log values, you can set the radar to have a log scale.

[Jamal NUMAN]

Originally Posted by p45cal

I agree. You can have a secondary axis in a radar chart but no more than that. I'd venture that a radar chart is not the best way to present these data. BTW, you don't need to have a separate table of log values, you can set the radar to have a log scale.

Thank you for the input