Below is the sample data and a few manipulations. The chart that I am attempting to create is one where the cnty1 would be listed left to right in ascending order. The vertical axis would be for the number of times that something appears in the top 5 employers. Each row is an employer, I just keep the names off for confidentiality. The chart would not be a bar or line chart but rather one where the industry's would be represented by different color dots.

For example, Cnty = '003' would have four dots (for industry 514,615,312,and 722) and a data label of 1 for each dot because each 3 digit industry code (Naics) only appears once in the top 5 list for each quarter.

It would not be a scatter plot because if industry 721 appeared 3 times and had cnty = 003 attached to it.. the dot would get bigger.

Edit: This would be a bubble-chart as found on