Welcome to Excel Avon
Rating Score chart in Excel
DOWNLOAD THE USED EXCEL FILE FROM HERE>>
In today’s post we will show you how to Create Rating Score chart in excel, although it is quite simple, Excel Rating Score is one of the best ways to represent performance-related data in Excel. Technically, a rating score chart is a mixture of a donut chart and a pie chart that overlap each other. The donut chart will become a meter while the pie chart will be converted to a pointer. Excel can be great help in creating a rating scale for any number of products.
This comes in very handy when you need to display performance charts in a space-constrained Excel dashboard. In this article, I will teach you how to create rating score Chart in Excel step by step with pictures.
By the way, our rating score Chart is going to be like this as you can see.
Create Rating Score chart in Excel
Create a table in excel sheet which will look something like this. In which there will be 3 parts score needle rest. Added formula for rest part. =200%-Sum(C2:C3)
Change the value Niddle cell, then select the data, go to the Insert, from here insert 2- D pie chart.
Delete legend and title from chart. Right click on the chart go to Format data series option. Change the angle of first slice to 270 Degree.
Make the border ‘no line’ then we will fill in the color of the entire chart. Fill border solid to needle part. and change fill the border with black color. Also increase the width of the needle part 1.5 to 3.
Set the value of the needle cell to Zero (0).
Right click on chart and go to select data option, then click add button.
Give the name of series and fill the 5 times {1} in series value 5 in last like {1, 1, 1, 1, 1, 5}
Again, add another series, then give the series value 5 time [1] in series value and 5 in last.
Click ok the click on chart, go to chart design and click on change chart type.
Change the chart type we can see all we will use pie chart for rating color chart and donut chart for rating chart tick secondary chart for both.
Now the chart will be look like this.
Now right click on the doughnut chart, click on format data point option, then increase the hole size of the doughnut chart. and change the angle of first slice 270*.
Change the angle of the 2-D pie chart.
‘No Fill’ the lower part in doughnut and 2-D pie chart. for Border Select ‘Solid Line‘ in Doughnut chart. and select ‘No Line’ For 2-D Pie.
And change the color of border.
Now do the color formatting of the chart, first color will be filled in doughnut chart then color will be filled in pie chart just keep the visibility of the 2-D pie chart at 50%.
Now go to ‘Insert‘ tab then go to ‘text‘ option ‘Insert text’ box in chart.
Drag the textbox and fill rating. Customize the text box like Add text Effect. and then fix text box in the chart.
Similarly add all the text boxes and fill the rating.
Go to ‘Insert‘ tab then go to ‘text‘ option Again insert text box drag the text box in the sheet.
Fill the value in the text box. Customize the text box like Bold, Color. and then fix text box in the chart.
Create textbox by copy paste and then fill value textbox. This will make our Rating Score chart look professional.
Now our Rating Score chart is ready.
Therefore, I hope that you have understood How to Create Rating Score chart in Excel, maybe if you do not understand anything, then you can comment us with the question, which we will answer soon and for more information, you can follow us on Twitter, Instagram, LinkedIn and you can also follow on YouTube.
DOWNLOAD THE USED EXCEL FILE FROM HERE>>
LEARN MORE DASHBORAD AND CHART TOPIC HERE
You can also see well-explained video here about How to Create Rating Score chart in Excel
