Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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!

 

 

Need Help

2 Replies

  • trebgatte's avatar
    trebgatte
    Most Valuable Professional
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

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