Home 
Search 
Today's Posts 
#1




Chart with double yaxis
Hello,
I have 2 sets of data for the same variables. One set of data is shown in %, from 50%100%. The other set of data is shown simply as values, from 025. Is there a way to combine these data sets onto one bar chart in order to compare the relative magnitude of the lines? In other words, can I make the yaxis show both 50%100% AND the numbers 025 next to each other so that the minimum and maximum heights (0%100% and 025) are equal and have the charts combine into one? Thanks! 
#2




Quote:

#3




Circular Bar chart?
Is this what you mean? http://www.excelcharts.com/blog/the...artrevisited/ Or perhaps one like this? http://peltiertech.com/WordPress/mag...visualization/ 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. On 26/09/2012 11:12 AM, DaveinVT wrote: Hello, Is it possible to create a circular bar chart, with the radii of the circle serving as the yaxis of the chart, and the perimeter of the circle serving as the xaxis? Thanks! 
#4




Yes, thanks

#5




Could you post some example dummy data? Far easier to make a graph with that.

#6




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...  [quote=William B. (Billby);1605870]Is this what you mean? http://www.excelcharts.com/blog/the...artrevisited/ Or perhaps one like this? http://peltiertech.com/WordPress/mag...visualization/ 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. 
#7




Chart with double yaxis
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. On 27/09/2012 12:06 AM, DaveinVT wrote: 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...artrevisited/ 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. 
#8




Circular Bar chart?
On Tuesday, September 25, 2012 at 11:12:03 PM UTC4, DaveinVT wrote:
Hello, Is it possible to create a circular bar chart, with the radii of the circle serving as the yaxis of the chart, and the perimeter of the circle serving as the xaxis? Thanks!  DaveinVT 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/radialbarchart/ 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; 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Doublestacked Bar Chart WITH a Secondary Y Axis Line chart?  Charts and Charting in Excel  
double axis, double problem (i hope only to me)  Charts and Charting in Excel  
how to do double "Y" axis bar chart  Charts and Charting in Excel  
How do I create a double y axis BAR CHART (not bar + line)?  Charts and Charting in Excel  
Marking point of intersection on double y axis chart?  Charts and Charting in Excel 