Shape Size as per Cell Value.

[premjeetgupta]

Is it possible in excel to create oval shape as per cell value.

I have attached a table and i need a chart in oval shape for all the circles.

I have created a manual chart for one circle. Is it possible to create like same for all the circle.

Also i need shape size should be auto change as per cell value. Please help...!

 

[bobhc]

You may find these Google links to help.

http://www.mrexcel.com/forum/excel-...ally-change-shape-size-based-values-cell.html

http://www.ozgrid.com/forum/showthread.php?t=70710

http://www.knowexcel.com/view/1456315-shape-size-dependent-on-cell-value.html

 

[Hui]

I haven't looked at your file but I would use a Scatter Chart and some named Formula to make an Ellipse
By doing this it requires no VBA Code and is totally scalable

See the attached example

 

[premjeetgupta]

Thank you both Ninja's for response.

As i have followed bobhc shared following link

http://www.ozgrid.com/forum/showthread.php?t=70710

and could able to get result as attached. But it seems it is not looking like bubble chart.

But my boss is happy with it. but the chart is dependent on VBA codes and i am not good in it.

is it possible to make a chart look like same as attached without vba help.

 

[Matt_B3]

I haven't looked at your file but I would use a Scatter Chart and some named Formula to make an Ellipse
By doing this it requires no VBA Code and is totally scalable

See the attached example

This must be some kind of sorcery

 

[Hui]

@Matt_B3
Please see attached file for how the 'sorcery' works