Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Charting » Bubble chart

Bubble chart

Previous | Next
Latest post Fri, Feb 15 2008 7:57 AM by CGONZALEZLE. 0 replies.

  • Fri, Feb 15 2008 7:57 AM

    Bubble chart

    Reply |Contact

    Hello all.

    I’m trying to duplicate a bubble chart using ellipses and I need a formula to calculate the size of them. I have calculated this formula:  ES = Square Root (BS / (1-cte))

    Where:

    ES - Ellipse size.BS - Bubble size.cte = Maximum value of the chart bubbles / -12000.

    Apparently the formula works.

    Please, Can you probe the formula in your charts and tell me the result. Do you know other formula?

    Thanks in advance. Best Regards.

    César. 

     

    PD: Excuse my awful English, sorry.

    Filed under: , ,
    • Post Points: 5
Page 1 of 1 (1 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.