create various Circles with values

[Joever]

Hi, I have a simple question . I have an list what i want to show in circles. Each circel is an % of the total.

Who can help me? value's will change next period.


1. 11.65
2. 42.05
3. 5.00
4. 1.90
5. 3.85
6. 7.58
7. 12.80
8. 8.30

Total 93.13

 

[James006]

Hi,

Your question calls for clarification ...

Do you mean you need 8 Circles ...?

How do you plan to show your Percentage ...?

 

[Joever]

Yes, I like to have 8 circles, and the biggest must be circle 2 with an value off 45.15%.
Total 93.13 = 100%

 

[James006]

Hi,

Sorry I do not understand your objective

In Message # 3

circle 2 with an value off 45.15%

In Message # 1

2. 42.05

And what does the word value ....means to you ?

Are you talking about a Pie chart ?

Are you after proportional circles ???

 

[Joever]

Hi, the value is calculated Value #2 : 42.05 = 45.15% of the total. < (42.05/93.13)*100% = 45.15%

What i'am lookiong for are proportional circles with the %.

[TABLE="width: 211"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD="align: right"][/TD]
[TD="align: right"][TABLE="width: 211"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]11,65[/TD]
[TD="align: right"]12,5%[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]42,05[/TD]
[TD="align: right"]45,2%[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5,4%[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]1,9[/TD]
[TD="align: right"]2,0%[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]3,85[/TD]
[TD="align: right"]4,1%[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]7,58[/TD]
[TD="align: right"]8,1%[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]12,8[/TD]
[TD="align: right"]13,7%[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]8,3[/TD]
[TD="align: right"]8,9%[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]93,13[/TD]
[TD="align: right"]100,0%[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[James006]

Hello,

To control the size of your Bubble Chart ...

see : https://peltiertech.com/Excel/Charts/ControlBubbleSizes.html

Hope this will help

 

[Joever]

Not what i want, but thnkx. Many links does'n work anymore.

 

[James006]

Hello again,

If you want to use Shapes ...

Do you have the possibility to upload a sample file with Dropbox or Google Drive ... ?

 

[MickG]

Have a look at this example file:-
https://app.box.com/s/yrlo3n4phbvx22aba6cv80bdn2ta7qer