Pivot Chart: compare actual value of 1 record with Avg, Min, Max of entire column

Pivot Chart: compare actual value of 1 record with Avg, Min, Max of entire column

Hello - as the title suggests I would like to make a scatter plot (or any chart that will display what I want to visualize), which plots the Avg, Min, and Max of values in a column, and then plot 1 value from a particular record from the same column.

For instance there are 20 test scores - the Avg, Min, and Max of all test scores are plotted - also little Johnnys particular scores is plotted on the same chart so he can see how he compares to the Avg, Min, Max.

Thank you!