Circular Bar chart?

[DaveinVT]

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!




--
DaveinVT

[William B. (Billby)]

Is this what you mean?
http://www.excelcharts.com/blog/the-consultants-chart-revisited/

Or perhaps one like this?
http://peltiertech.com/WordPress/magazine-quality-vs-informative-infovisualization/

There are also plenty of third party product$ that can do what you want.

Go to: http://images.google.com/advanced_image_search?hl=en
And enter the words: excel circular bar chart
Then if you see an image that looks interesting click
on it and visit the site where the image originated from.

Have fun,

William B.

[DaveinVT]

Spencer101;1605861 Wrote:
> 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?


+-------------------------------------------------------------------+
|Filename: SAMPLE-FIG1.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=601|
|Filename: SAMPLE-FIG2.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=602|
+-------------------------------------------------------------------+



--
DaveinVT

[DaveinVT]

Thanks for the reply. I posted a jpeg of what I want to recreate (and
then play with a bit) in this tread he
http://www.excelbanter.com/showthread.php?t=447224

I guess I should have asked all my questions in one thread to keep it
all together...

----------------------------

William B. (Billby);1605870 Wrote:
> Is this what you mean?
> http://www.excelcharts.com/blog/the-consultants-chart-revisited/
>
> Or perhaps one like this?

> http://tinyurl.com/9zvdgnn

>
> There are also plenty of third party product$ that can do what you
> want.
>
> Go to: http://images.google.com/advanced_image_search?hl=en
> And enter the words: excel circular bar chart
> Then if you see an image that looks interesting click
> on it and visit the site where the image originated from.
>
> Have fun,
>
> William B.

--
DaveinVT

[William B. (Billby)]

Hi Dave, I checked out your jpeg and the Excelbanter blog.
What your are trying to achieve is quite complex for Excel.
A polar chart might do what you require but I couldn't find
any 'free' examples at that level of complexity...

The Excel 'Sparklines' charting mentioned elsewhere by Ben
is quite extensive but doesn't appear to have a direct
solution for your problem. Best of luck with your research
and eventual success in plotting it. WB.

[hugh...@gmail.com]

It's been a long time since this was asked, but in case there are any other searchers out there, this page gave me the solution I used to build mine in MATLAB.

http://interworks.co.uk/blog/radial-bar-chart/

This website shows you the trigonometric solution you need to plot a line using the regular old plot function. Each line has two points, and you plot your first one like this in MATLAB:

plot([innerx outerx], [innery outery])

When I made mine, I selected r1 to the same number for all observations and r2 to be the value for that observation. Here's all the code for MATLAB.

values = [3 4 1 8 9];
nvalues = size(values,2) %values has 5 rows and 1 column.
indices = 1:nvalues
angledeg = 360/nvalues;
anglerad = degtorad(angledeg);
angles = indices.*anglerad
innerr = 5; % pick anything you want
values = innerr + values;
cosines = cos(angles);
sines = sin(angles);

xinners = innerr.*cosines;
yinners = innerr.*sines;

for i = indices
plot([xinners(i) xvalues(i)], [yinners(i) yvalues(i)])
end

xvalues = values.*cosines;
yvalues = values.*sines;