How to make a readable radar chart with normalized values and absolute value labels; for example, this table:
TKS!
[Edited by Moderator]
Original Title: Radar chart
MacBook Air, macOS 15.6
Radar charts typically have one axis that has graduations (numbers) on it and all the axes use the same scale. So all your data needs to be of a similar scale and all positive. Yours has one column as small as 0.07 and another as large as 7 million and that doesn't work well as a radar chart. I'm not sure your data is really meant for a radar chart. NPV is not really "radar" value because projects can be of vastly different sizes. You have other data (IRR) that can be negative and that doesn't work for a radar chart. But if you want it all on a radar chart, you can divide each column by a "nominal" number or by the maximum value or do some other math/functions to get them all into a similar range.
So, one simple thing would be to create another table that divides each column of your data by the maximum value in the column and multiplies by 10. As long as all values are positive, this will give you a 0-10 scale for each category. I'm not sure how you would handle negative values. Using absolute value would not be correct. You could use MIN(the_value,0) so it never goes below 0 but you will have to work out what to do if the maximum value is negative or 0.
Radar charts typically have one axis that has graduations (numbers) on it and all the axes use the same scale. So all your data needs to be of a similar scale and all positive. Yours has one column as small as 0.07 and another as large as 7 million and that doesn't work well as a radar chart. I'm not sure your data is really meant for a radar chart. NPV is not really "radar" value because projects can be of vastly different sizes. You have other data (IRR) that can be negative and that doesn't work for a radar chart. But if you want it all on a radar chart, you can divide each column by a "nominal" number or by the maximum value or do some other math/functions to get them all into a similar range.
So, one simple thing would be to create another table that divides each column of your data by the maximum value in the column and multiplies by 10. As long as all values are positive, this will give you a 0-10 scale for each category. I'm not sure how you would handle negative values. Using absolute value would not be correct. You could use MIN(the_value,0) so it never goes below 0 but you will have to work out what to do if the maximum value is negative or 0.
I think you need to provide more information on what you're hoping to achieve.
It isn't clear what data from the above table you're trying to incorporate into a chart, nor what values you want to see.
What I would like to achieve is, on the same radar chart, the performance of the two scenarios: therefore, mapping IRR, NPV, Breakeven, and Capital. Since they have different units of measurement and scales, the data must be normalized, for example, by setting each major variable to 100. And I know how to do this. What I'm unable to do, and for which I need help, is placing the absolute (and not normalized) values in the chart as labels. Below is the chart I managed to create and in which I would like to place the labels.
[Edited by Moderator]
I do not know how you would do that. Sorry.
Creating readable radar charts with normalized values and absolute value labels in Numbers app
