Create Dazzling Rating Charts

๐Ÿ“Š๐ŸŒŸ Create Dazzling Rating Chartsย ๐ŸŽจ


Excel offers powerful tools for visualizing data, and one popular visualization is a rating chart. In this blog post, we will explore how to create a rating chart in Excel using the REPT function and conditional formatting. By combining these two features, you can create a visually appealing chart that effectively represents ratings.


Lights, camera, data! The data we have contains movie names, directors, genres, and ratingsโ€”steal the spotlight. Stand out with unique names, diverse genres, and impressive ratings. Prepare to create stunning rating charts in Excel using the powerful REPT function and dynamic conditional formatting. Letโ€™s bring your data to life with visual excellence.

Letโ€™s create a rating chart in Excel using the CHAR function. This function enables us to display circles that are fully shaded, half-shaded, or empty. By utilizing the CHAR function in combination with calculations, we can generate the rating chart based on the provided information.

To Determine the Calculations for the Rating Chart

  1. Use the ROUND function in Excel to round the value to the nearest decimal place.
  2. Utilize the CEILING function to round the value up to the nearest multiple for the half-shaded circle.
  3. For the empty circle, It is a simple Subtract the count of fully-shaded and half-shaded circles from the total number of circles. This methodology involves using the ROUND function for fully shaded circles, the CEILING function for half shaded circles, and a simple calculation for empty circles.

To Create a Visually Appealing Rating Chart

  1. Use the following function expression in Excel to create a rating chart.=REPT(CHAR(152),N4)&REPT(CHAR(186),O4)&REPT(CHAR(153),P4)
  2. Join multiple functions together using the & symbol to combine their results.
  3. The chart generates circles based on assigned values: 152 for fully shaded, 186 for half-shaded, and 153 for empty circles.
  4. For a proper appearance, set the font as Wingdings 2.


To make it a visually appealing and dynamic rating chart in Excel, you can utilize conditional formatting

  1. Select the desired cells and go to Conditional Formatting > New Rule.
  2. Choose Use a formula to determine which cells to format and enter =M4>3 in the formula bar (M4 holds the rating).
  3. Format the font color as green for ratings >3. Apply the rule.
  4. Repeat the process for =M4<=3 with red font color for ratings โ‰ค3. Now, the rating chart will automatically update as you change the rating, resulting in a visually appealing and dynamic representation.

Improve the visual appeal of your data presentation by hiding the calculation columns. This keeps the focus on the final rating chart.

Behold our vibrant rating chart! Immerse yourself in the magic of eye-catching visuals.


Our rating chart has undergone a remarkable transformation into a vibrant and dynamic masterpiece through the clever utilization of REPT and CHAR functions, complemented by the magical touch of conditional formatting. Prepare to captivate and engage your audience with this visually stunning representation of the data.

For detailed training in Excel, contact us.

Advanced Excel Training in Chennai, Mumbai, Delhi, Pune for Corporates

Email id:


LinkedIn: @excelprodigy



Write a comment

Your email address will not be published. Required fields are marked *