folionsa.blogg.se

They are mostly used in business, social, economic and other fields to study the relationship of data.

We can show the relationship between different datasets. Thus, the third value determines the size of the Bubble.īubble Charts are available in Excel 2010 and other versions of MS Excel. If you wished also to express the country’s GDP, you could proportionally enlarge or shrink each plotted data point in the form of a Bubble– so as to simultaneously highlight the relationship between birth rate and life expectancy, but also to highlight the GDP of the countries. Excel functions, formula, charts, formatting creating excel dashboard & othersĮxample: A typical XY Scatter chart might be used to display the relationship between birth rate and life expectancy at birth, with the county as the unit of analysis.