Progress indicator Column 2
 
 

After choosing the type of Excel chart click the next button.
Now in the box of dialogue Source Data select the range with the data for the Excel chart .
You can choose to display by rows or columns.

 
Sample

Open the  dialog box: insert Sparkline .
Choose the type  Progress Indicator Column 2 .
Select the range  of data and press finish.
 
 

The result shows the Excel graphic, with the orange circle above the marker from average with value of 42.50.