Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
Is it possible to create a circular bar chart, with the radii of the circle serving as the y-axis of the chart, and the perimeter of the circle serving as the x-axis? Thanks! |
#2
![]() |
|||
|
|||
![]()
What exactly is it you're trying to plot on this graph?
|
#3
![]() |
|||
|
|||
![]()
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? Last edited by DaveinVT : September 26th 12 at 12:54 PM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Circular or semi-circular chart | Charts and Charting in Excel | |||
How do I copy a pie chart (just the circular pie) into powerpoint | Charts and Charting in Excel | |||
Circular | Excel Worksheet Functions | |||
Circular? | Excel Programming | |||
Ultimate circular problem for chart creation | Excel Discussion (Misc queries) |