Star ratings chart -Excel

A cool visual -star ratings chart, for use in rating products, students' scores, hotels/restaurants et al. the ratings look like they are static but are actually charts
Link to workbook:
docs.google.com/spreadsheets/...

[@IvanCortinas_ES]

Absolutely visual. He knew several tricks with the REPT function, but he had never overlapped the sets to create that illusion. It is a more professional presentation, without a doubt. Thanks for sharing Victor.

[@ExcelMoments]

Thank you Ivan, the main advantage for me is being able to have a 0.5 show up in the rating which REPT can't. It sure looks better than REPT though 😀

[@user-jo7tx4qz1l]

Fantastic i am happy to see your excel tricks

[@ExcelMoments]

Glad to hear that

[@markpodesta4605]

Thank you Victor. I will download a copy.😊

[@ExcelMoments]

Great. You are welcome

[@GrainneDuggan_Excel]

Lovely solution Victor! I would have tried a bar chart underneath with a visual on top showing 5 stars. The bar chart would show through the overlay stars only. This method is simpler and less likely to break. Nice one

[@williamarthur4801]

Fantastic, I'm nor much good with charts to always enjoy this sort of thing, I did try on my own,
and the last part I did different, I used I made the second starts white and then played around with primary / secondary axis till it looked right. but then realized I no longer had the correct axis labels , hmm, will work through again.

[@Luciano_mp]

Good tip! Thank you Victor!

[@ExcelMoments]

Thanks for the feedback

[@davidakomolafe3609]

Such a wonderful way to start off the year 🥳
Happy new year Engr Victor!

[@ExcelMoments]

I absolutely agree

[@excelpro365_1]

You guess me right, I am always like oooh Victor this is sumptous, where do we go from here. you are doing the most.

[@ExcelMoments]

Hahahahaha, we just put it out as it comes!!

[@jazzista1967]

Hello Victor.. Happy new year. I am catching up with your videos Finally ... very nice trick on the overlapping the starts.

[@ExcelMoments]

Hey Luis, good to have you back
Trust that you had a very nice break and spent some time wirh the family, now we are back to Excel 😁

[@jazzista1967]

Hi Victor... thanks for your reply. Yes I had a good break. Hope you did too! Look forward to more videos...

[@ExcelMoments]

@@jazzista1967 I have been posting "shorts", I trust that you didn't miss them

[@jazzista1967]

Victor: Thanks for letting me know. I was not aware of your short videos . Let me look at them this evening... its early in this part of the world

[@Mark-sf4kh]

Sharp!!!!

[@ExcelMoments]

i think so 😁😁

[@excelpro365_1]

This is amazing

[@ExcelMoments]

Thanks for the feedback