I have typical web app. where the user effectively makes a query and he/she gets back some data. The data is in the format of 1 dimension/1 metric. For instance:
What I discovered is that if I have two or three cities a pie chart is perfect, however if I have hundreds of cities a Pie chart is awful. (and hence I switch to a table chart)
My question is:
What's the algorithm to choose the most appropriate chart depending on the data ? Have people made some studies on this ?
For instance one simple answer (e.g. my current implementation) says:
if the number of cities is smaller than 5 use a pie chart
else use a table chart
Can somebody suggest a better algorithm ?
Also can somebody point me to some external resources where this problem is discussed?