Star ratings chart -Excel
Вставка
- Опубліковано 27 сер 2024
- 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.co...
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.
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 😀
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
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.
Fantastic i am happy to see your excel tricks
Glad to hear that
Thank you Victor. I will download a copy.😊
Great. You are welcome
Such a wonderful way to start off the year 🥳
Happy new year Engr Victor!
I absolutely agree
You guess me right, I am always like oooh Victor this is sumptous, where do we go from here. you are doing the most.
Hahahahaha, we just put it out as it comes!!
Good tip! Thank you Victor!
Thanks for the feedback
Hello Victor.. Happy new year. I am catching up with your videos Finally ... very nice trick on the overlapping the starts.
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 😁
Hi Victor... thanks for your reply. Yes I had a good break. Hope you did too! Look forward to more videos...
@@jazzista1967 I have been posting "shorts", I trust that you didn't miss them
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
Sharp!!!!
i think so 😁😁
This is amazing
Thanks for the feedback