cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DHB Member
Member

Missing Data in Scatter Chart

I created a simple table which I converted into a scatter chart.  The problem is that much of the data that can be seen in the table is not shown in the scatter chart.  i.e. the table shows 17 people with an Activity Score over 80 that also have an Average Test Score.  When I switch it to a scatter chart only one of these is represented (Activity Score 84.4, Average Test Score 93.0).  Where might the other 16 have gone?  Could it be there is too much data in the table (23,748 people)?

 

Scatter.png

 

Thank you in advance for your help.

 

Best,

 

DHB.

1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: Missing Data in Scatter Chart

Hi @DHB,



Could it be there is too much data in the table (23,748 people)?

Yes, it should be the cause.

 

In this scenario, you may need to pick a category that doesn't have too many values.

 

According to this article, if the category has more than 2,000 values, you see a note that the chart is “showing representative sample” rather than all the categories. Really, it's hard to see individual bubbles if you have a lot of them.Smiley Happy

 

Regards

2 REPLIES 2
v-ljerr-msft Super Contributor
Super Contributor

Re: Missing Data in Scatter Chart

Hi @DHB,



Could it be there is too much data in the table (23,748 people)?

Yes, it should be the cause.

 

In this scenario, you may need to pick a category that doesn't have too many values.

 

According to this article, if the category has more than 2,000 values, you see a note that the chart is “showing representative sample” rather than all the categories. Really, it's hard to see individual bubbles if you have a lot of them.Smiley Happy

 

Regards

DHB Member
Member

Re: Missing Data in Scatter Chart

Thanks for your reply.  It's good to know I wasn't doing something wrong.