HELP - How to Create a Scatter Chart with a Matrix Table

[Anonymous]

Hi,

I have created the below matrix and want to convert it to a scatterplot.

I do so by clicking the "scatter chart" button in the visual types.

But I only get a chart with two dots vs a scatter with points that represent both avg ratios of M/F in a specific grade. 

not good

good

Any tips/tricks with help!

[trebgatte]

Remove the field in values so it'll stop summarizing the chart. Leave the rows and column fields values to have it map each instance. 

[Anonymous]

If I removed the "field in values" I lose the option to change it to a scatterplot.