Quote:
Originally Posted by Spencer101
What exactly is it you're trying to plot on this graph?
|
I'm trying to plot data collected about fish populations taken from sample sites which are arranged geographically around a specific point. This is why I'd like the bar chart to be plotted in a circle -- to give a geographic sense of each site in relation to one another.
Each site has data about both the male and female fish which were captured, and this is best shown as stacked bars.
I'm essentially trying to recreate these charts and am also trying to find a way to plot both charts together (as an overlay perhaps?) Plotting together, particularly in this format is tricky because too many bars stacked next to each other renders the data unreadable. Furthermore, the data in one chart is measured as a % (from 50%-100%) and in the other is measured as a count (from 1-20). I suppose I can simply "translate" the pure numbers to %, beginning at 50% (with 1 being 50% and 20 being 100%)...
In any case, just getting this stuff in a chart in excel will allow me to play with it and hopefully find the best solution. Is it possible to make this circular bar chart thing happen, or will I have to just fabricate something in illustrator?