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 %.

	1 11,65 12,5% 2 42,05 45,2% 3 5 5,4% 4 1,9 2,0% 5 3,85 4,1% 6 7,58 8,1% 7 12,8 13,7% 8 8,3 8,9% 93,13 100,0% <colgroup><col><col span="2"></colgroup><tbody> </tbody>

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

 

[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