Regarding radar chart and numbers
Hi,
I was wondering if there is any chance to create a radar (spider) chart in numbers?
That is the only function I am missing.
Hi,
I was wondering if there is any chance to create a radar (spider) chart in numbers?
That is the only function I am missing.
Yes I guess so.
Now I am trying to make the radar chart update automatically.
For example if i search for a name in a database "B" then the database only shows the data of B person. But my radar chart does not automatically update and still shows the data of A person in it. I am not sure how to make it dynamic. (You can see in the photo I have selected value in a radar chart category referring to table D2 cell).
Is there any chance to make it dynamic and update automatically?
I think you should consider storing the data in a slightly different way.
the formula in the bottom table (cell B2 selected) is:
=AVERAGEIFS(Data::E,Data::A,B$1, Data::D,$A3)
please note I live in the US so we use the period as the decimal separator. based on how you input the data, you live in a locale that uses the commas as the decimal separator. Therefore, you should modify the formula so the field delimiters (the commas) are changed to semicolons
change from:
=AVERAGEIFS(Data::E,Data::A,B$1, Data::D,$A3)
to
=AVERAGEIFS(Data::E;Data::A;B$1; Data::D;$A3)
Thank you for your tip! It was really helpful and solved the problem.
Though I did some modifications to your formula.
I don't really need to count averages because i will draw more than one series in a radar chart. For a specific date I have made a new column TEST (test 1, test 2 etc). I am also now able to use Search cell effectively.
Thank you!
If there is, you'll find it listed with the other types available in the menu opened y clicking the Charts button.
If not, go to the Numbers menu, choose Provide Numbers Feedback, and make a Feature Enhancement request directly to Apple.
Regards,
Barry
PS: Can't give you a more definite answer, as my version of Numbers is well back of the current version.
B.
Take look at this example I made some time back:
https://www.dropbox.com/s/axriwu9dnore13f/Mulitaxis_v6p2.numbers?dl=0
Thank you.
Too bad numbers don't have this feature.
A feature Enhancement request has been made.
Regards
This looks awesome.
Thank you!
did any f these post solve your problem?
Regarding radar chart and numbers