Hi this is great! Im tring to make a wind rose with an excel file of actuall degrees and time at 24 hours. all the excel ytube ask me to change the degrees to directions. I need to find a way to make the same wind rose you made here but with the degrees. any ideas?
Hi i think i might have done a video not exactly what you want but will help with your question - "Salary Structure Floating Bar Chart with Customized X axis": ruclips.net/video/B02i9mvWkwQ/видео.html
THANKS YOU VERY MUCH FOR THIS AND THE PREVIOUS TUTORIAL ON THE WIND ROSE CHART METHOD IN EXCEL. I HAVE ONE QUESTION: IS IT POSSIBLE TO CHANGE THE ALIGNMENT OF THE DATA LABELS SO THAT THEY ARE PLACED ON AN ANGLE LIKE SPOKES ON A WHEEL? THANKS VERY MUCH
This looks good but it is limited to only some of the countries in your example since you surpass the number of available degrees with only 18 of your countries - which makes the other countries not part of the chart.
Amazing looking chart. But for me it looks not really dynamic and not easy adjustable. If my data is changing, each time I will need to build this piece of art again and again. But visual is really impressive. Thanks!
One way to do it is to link the value next to each degree to the original table, instead of just copying it. This is done using the equal to symbol and then selecting the corresponding cell. So each time you change your table, the chart adjusts itself.
@@CariprosHRAnalytics I did it in sort of a cheat way, i had 12 bars, I made 12 360 value listing with only the values i wanted in 30 slots (because 360/12=30) and the rest of values 0, i did this in a way it would not be on top of each other like (1 0 0 0 0 - 0 1 0 0 0 - 0 0 1 0 0 - 0 0 0 1 0....) then snapped them together on top of eachother and i was left with a 360 radar chart with individual bars i could mess with... It's hard to explain by text but i think you understood
Hi this is great! Im tring to make a wind rose with an excel file of actuall degrees and time at 24 hours. all the excel ytube ask me to change the degrees to directions. I need to find a way to make the same wind rose you made here but with the degrees. any ideas?
Thank you for having minimal cuts in the video it made it much easier to follow.
Glad it was helpful!
This was EXACTLY what I was looking for! Easy to follow, too! Thank you!
Please how can we add directions (N, S, E, W to the plot? 🙏🏼
Can this chart be made dynamic
Absolutely great chart and fantastically explained! Thank you very much.
This is awesome! Thank you very much!
GREAT video! Can you please explain how to add the labels from another column? Thank you so much!
Hi i think i might have done a video not exactly what you want but will help with your question - "Salary Structure Floating Bar Chart with Customized X axis": ruclips.net/video/B02i9mvWkwQ/видео.html
THANKS YOU VERY MUCH FOR THIS AND THE PREVIOUS TUTORIAL ON THE WIND ROSE CHART METHOD IN EXCEL. I HAVE ONE QUESTION: IS IT POSSIBLE TO CHANGE THE ALIGNMENT OF THE DATA LABELS SO THAT THEY ARE PLACED ON AN ANGLE LIKE SPOKES ON A WHEEL? THANKS VERY MUCH
thankyou for detailed explanation
Thanks for uploading this amazing tutorial,
Kind regards,
Me ☺️ (Tajikistan🇹🇯, Dushanbe)
Subscribed 👍
We need more of these Excel goods
#publicwifi
Thanks... learned a lot
Thankyou verymuch with a simple explanation.
This looks good but it is limited to only some of the countries in your example since you surpass the number of available degrees with only 18 of your countries - which makes the other countries not part of the chart.
Super! simplistic explanation of a complex chart. One question - did you create labels manually?
I showed how I create the label in the part II video ruclips.net/video/3ALO9tG7Xh4/видео.html
Very informative. thanks.
Amazing looking chart. But for me it looks not really dynamic and not easy adjustable. If my data is changing, each time I will need to build this piece of art again and again. But visual is really impressive. Thanks!
One way to do it is to link the value next to each degree to the original table, instead of just copying it. This is done using the equal to symbol and then selecting the corresponding cell. So each time you change your table, the chart adjusts itself.
wonderful. thank you very much.
thank you very much. it's very helpful
You are welcome!
I have a question... Is it possible to make each bar a color? I need to have different colors for each bar to distinguish them.
Hi I just quickly checked, doesn't seem to be able to do this in Excel...I will let you know if I can find a solution outside Excel...
@@CariprosHRAnalytics I did it in sort of a cheat way, i had 12 bars, I made 12 360 value listing with only the values i wanted in 30 slots (because 360/12=30) and the rest of values 0, i did this in a way it would not be on top of each other like (1 0 0 0 0 - 0 1 0 0 0 - 0 0 1 0 0 - 0 0 0 1 0....) then snapped them together on top of eachother and i was left with a 360 radar chart with individual bars i could mess with... It's hard to explain by text but i think you understood
Thanks for the effort, good video. But too much manual work
But therre is no true North direction. You have North slightly to the left/right.