Also I want to show top 5 states on chart and remaining as others. I did this by
My Graph shows
Problem: Here yellow portion which shows 4% are having State value as 'Null'. I want to show these Nulls to include into the 'Others' and want only 5 states with valid value to be displayed. How to do this?
logically the others contain a lot of different values of state and all have less than the top 5 in your example and the null values is considerated as one state this is why it's counted with the top 5