After choosing the type of chart click the next button.
Now in the box of dialogue Source Data select the range with the data for the chart .
You can choose to display by rows or columns.
Open the dialog box: insert mini chart .
Choose the type Progress Indicator Column 2 .
Select the range of data and press finish.
The result shows the graphic, with the orange circle above the marker from average with value of 42.50.
