Forum Discussion

DHB's avatar
DHB
Helper V
9 years ago
Solved

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...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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.:smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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.:smileyhappy:

 

Regards

DHB's avatar
DHB
Helper V
9 years ago

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