It might not be the best way but I would do it using ExecuteSQL to get the names of the states in a field (this is the label series) and another one to get the population of these 5 states in another field (data series). Then you can chart based on limited data.
That way your chart would always show on the record, irrespective of the found set.
Hope this helps!
Thanks for your response. I am unfortunately a complete novice when it comes to SQL. Could you point me in the right direction in terms of the commands I should research or syntax to use?
To help you a little bit further: look into the Fetch First and Order By clauses