I have about 4000 rows in my excel doc, each one for a different county, but its quite obvious that many of them are not getting published in the charts. Not sure why
I think you need state in the detail as well as shown below
And then only 6 of them are not found, for these either the name is not matched with tableau default or you may need manually input the corresponding names.
Hope this helps
Retrieving data ...