Bulleyes/Bubble Chart

[VolOdd]

I need to create a chart that looks very much like this one: http://blogs.technet.com/cfs-filesy...api/7041.clip_5F00_image002_5F00_18B87D97.gif

The inputs would be:
1.) Name of the pie slice (I'd prefer this to be dynamic to allow me 1 to n slices)
2.) Year that it would be placed on the roadmap
3.) Value to the company (size of bubble)
4.) Risk to the company (color of bubble)

I'm struggling with how to even begin, I hope you can give me some pointers.

 

[Faseeh]

Hi Volodd

Can you wait for till tomorow so that i can try it out once, i think it could be tried! Thanks

 

[NARAYANK991]

Hi ,

I have no idea why you need to create something which is going to be quite complex and time-consuming ; I think one of the comments ( by Vijay ) in this link is for a situation similar to yours ; Tushar Mehta's answer is that it can be done using the techniques mentioned in the blog post. See if it helps.

http://dailydoseofexcel.com/archives/2013/04/28/draw-a-circle-in-an-excel-chart/#comments

There are other advanced charting techniques discussed here , which may help :

https://sites.google.com/site/e90e50fx/home/creative-and-advanced-chart-design-in-excel

However , my personal opinion is that a chart is supposed to represent the idea "a picture is worth a thousand words" ; the picture you have shown contains a pictorial representation of so much information , that is it practically self-defeating. It would have been far better to present the facts as text !

Narayan

 

[VolOdd]

Hi Volodd

Can you wait for till tomorow so that i can try it out once, i think it could be tried! Thanks

Thanks!

 

[VolOdd]

Hi ,

I have no idea why you need to create something which is going to be quite complex and time-consuming ; I think one of the comments ( by Vijay ) in this link is for a situation similar to yours ; Tushar Mehta's answer is that it can be done using the techniques mentioned in the blog post. See if it helps.

http://dailydoseofexcel.com/archives/2013/04/28/draw-a-circle-in-an-excel-chart/#comments

There are other advanced charting techniques discussed here , which may help :

https://sites.google.com/site/e90e50fx/home/creative-and-advanced-chart-design-in-excel

However , my personal opinion is that a chart is supposed to represent the idea "a picture is worth a thousand words" ; the picture you have shown contains a pictorial representation of so much information , that is it practically self-defeating. It would have been far better to present the facts as text !

Narayan

I normally wouldn't try this, but it would literally take a thousand words to represent what that chart does... it is a simple roadmap with each area of the pie representing a "bucket" of technology and the tools associated with that technology. Not to be argumentative, but I think that the chart I linked and what it is trying to represent is fairly straightforward for consumption by an executive.