Is there a formula to aid in organizing the data by count (many) ranges to generate a chart?

StanCub 

For clarity, I am going to use alphanumeric identifiers for the groups of counts – G01, G02, etc. – and I'll call those CountGroupIDs. To derive the CountGroupID values, add a helper column and put this formula into it (specifically for row 2; copy it down as needed):

="G" & TEXT( CEILING.MATH(C2/200), "00" )

(Blank or somewhat-negative values for Count will be assigned G00. I'm also assuming that Count does not exceed 20,000; if it could, you can just add an extra zero in the last argument, making the IDs four characters in length.)

That might be enough of an answer to get you to a solution using a pivot table. If not, or if you don't want to use a pivot table…

I would create an additional worksheet, and load up column A with the possible CountGroupID values. (If you want that list to contain only the groups that actually exist, you can use a formula like =UNIQUE(Sheet2!D2:D99999).)  Use the following formula in column B (in row 2; copy it down as needed) to get data for the chart:

=COUNTIF( Sheet2!D:D, A2 )

(Of course, replace the "D:D" if you used a different helper column on Sheet2.)

If you wish, sort that range on the second column (Largest to Smallest). Chart as desired.