Is it possible to create a bar chart in a circle, where the x-axis is represented by the perimeter of the circle and the y-axis is represented by the radii of the circle?
I need to recreate the following 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?
They are organized in a circle in order to represent the geographic location of each site relative to one another (all sites radiate from a central point)