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.
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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.
Take look at this example I made some time back:
https://www.dropbox.com/s/axriwu9dnore13f/Mulitaxis_v6p2.numbers?dl=0
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
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.
This looks awesome.
Thank you!
did any f these post solve your problem?
Regarding radar chart and numbers