How to transform a Bar Chart to Wind Rose Chart I

[@mayakaplanoved2090]

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?

[@abdulkarimarmah4841]

Please how can we add directions (N, S, E, W to the plot? 🙏🏼

[@SimbolicTube]

This was EXACTLY what I was looking for! Easy to follow, too! Thank you!

[@jonathanalbershardt3200]

Thank you for having minimal cuts in the video it made it much easier to follow.

[@CariprosHRAnalytics]

Glad it was helpful!

[@aks1008]

Can this chart be made dynamic

[@tomekbzdyra8717]

Absolutely great chart and fantastically explained! Thank you very much.

[@MarysLake]

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

[@rafiqboronov1135]

Thanks for uploading this amazing tutorial, Kind regards, Me ☺️ (Tajikistan🇹🇯, Dushanbe)

[@rafiqboronov1135]

Subscribed 👍

[@rafiqboronov1135]

We need more of these Excel goods #publicwifi

[@cintagothy]

GREAT video! Can you please explain how to add the labels from another column? Thank you so much!

[@CariprosHRAnalytics]

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": kzbin.info/www/bejne/eGGVmmyjq7yerbM

[@harshamaloo1801]

Super! simplistic explanation of a complex chart. One question - did you create labels manually?

[@CariprosHRAnalytics]

I showed how I create the label in the part II video kzbin.info/www/bejne/aXKvgGyqfJyLnpY

[@Mauriloborges]

This is awesome! Thank you very much!

[@ramkyadi]

thankyou for detailed explanation

[@ramkyadi]

Thankyou verymuch with a simple explanation.

[@DavidSilva159]

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.

[@CariprosHRAnalytics]

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...

[@DavidSilva159]

@@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

[@MohamedIsmail-gi4ki]

Thanks... learned a lot

[@ClintCompton1]

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.

[@ericatlas]

Very informative. thanks.

[@allabout1135]

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!

[@MrFcasas]

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.

[@agansartika]

thank you very much. it's very helpful

[@CariprosHRAnalytics]

You are welcome!

[@FaysalEasyExcel]

wonderful. thank you very much.

[@brianfong5711]

But therre is no true North direction. You have North slightly to the left/right.

[@muhammadchoudhry5864]

Thanks for the effort, good video. But too much manual work