Choose a Sign-in Option
A bubble chart is a graphical tool that will let you display three types of data on the same graphic. It will let you see all three factors interact on the same graphic.
What it is: A bubble chart is a charting tool that displays three types of data on a single chart. The chart is a variation on the scatter plot with the added dimensions of differing sizes for the points displayed on the scatter graph. The bubble chart is normally shown as a box or map where the x and y axis measure the width and height of the box. The x and y axis create four quadrants, and the bubbles (of different sizes) are mapped onto the grid, letting their location represent the x and y factors.
What it does: It allows you to see three factors for a single entity and compare multiple entities across all three factors. As an example, the chart could compare price, volume, and percentage profitability on a single chart. A well-designed bubble chart will allow conclusions to be drawn for the size and location of the bubbles on the chart.
How is it used: There are many times when you are comparing companies, places, people, and other entities and you want to compare them to multiple factors. A line or bar chart only lists one factor. A bar and line chart (or double line or bar chart) compares two factors. A bubble chart creates a three-dimensional graph without the false illusion of a three-dimensional (x, y, and z axis) chart that tries to imply height, width, and depth.
Where: Very popular in comparing two factors along the x and y axis and often the z axis (the one that describes the diameter of the bubble) is used to indicate the size of the entity. If you define the x and y axis so they are mapping the location of the entities in the map created within the box and the quadrants. It is common that the proximity of the entities on the chart means they have similar x and y characteristics and the size of the bubbles differentiates them along with a third factor (often a measurement of size). Examples of common bubble charts include the following:
Relative competitive position: This is a chart that compares competitors on sources of competitive advantage. This chart displays the advantaged positions competitors have related to price, cost, and size.
Financial characterization: This is a chart that compares industries, companies, or products to profitability versus industry growth. You can determine the attractiveness in investing in industries, companies, or products based on competitive advantage (as measured by relative profitability), industry growth, and size of profit or revenue.
Supply chain outsourcing country analysis: This is used to determine which country should be considered as a source country from which to manufacture goods to be imported to the US.
Why: Bubble charts are used to compare and contrast different companies, countries, and other entities on three separate factors.
Where it shouldn't be used: Bubble charts should not be used when you intend one of the axes to be a category axis. A category axis defeats the mapping characteristics of the scatter plot. Both the x and y axis are intended to be valued.
Any restrictions: None
Warnings: Do not make the bubbles larger than the size of the chart or create too much overlapping. You can control this by making the standard size bubble smaller.
Gathering data
Determine which data sets will highlight the insights necessary to make your recommendations.
Particularly consider which data will create common recommendations based on proximity to each other (for x and y data).
Use z data to measure differentiation between alternatives based on size or magnitude.
Place the data into a table.
Analysis of data
Use the data table as the source for the bubble chart.
Create the chart and format as necessary to highlight insights.
Interpretation of results
Identify what actions or recommendations are most relevant for each quadrant.
Determine which corner of the quadrant is most valuable in making the recommendation.
Use the size of the bubble to differentiate between alternatives in the same quadrants.
Use the size of the bubbles to determine which quadrants might be the most advantaged positions in the past or the future.
Presentation of results
The presentation of the bubble chart itself is the most valuable part of the presentation.
It can be valuable to label the quadrants as to their indications or recommendations.
It can be valuable to show the chart without any data, but just the insights to be gained or recommendations to be made from each quadrant.
The bubble chart is the representation, and the recommendations come from the proximity of the points on the chart and the size of the bubbles. Normally there is a recommendation associated with each quadrant of the chart. You should look for the likely suggested ideas based on the conditions described in the quadrant. See the examples below for specific examples of how to form recommendations.
Below are examples of bubble charts and what the output representation suggests for recommendations:
Relative competitive position: This is a chart that compares competitors on sources of competitive advantage. This chart displays the advantaged positions competitors have related to price, cost and size.
X axis is relative cost (How much larger or smaller is the cost of each competitor compared to the industry average cost?).
Y axis is relative price (How much larger or smaller is the price charged by each competitor compared to the industry average price?).
Z axis or size of bubble measures the total profitability or revenues of each competitor.
Look for the following as you view the chart:
The northeast quadrant has competitors with advantaged cost and price. They should try and grow.
The southeast quadrant has competitors with advantaged cost and disadvantaged price. They should try and differentiate their product to increase price or grow volume.
The northwest quadrant has competitors with advantaged price and disadvantaged cost. They should try and reduce the cost of their product to increase profit or strengthen differentiation or price position to sustain profitability.
The southwest quadrant has competitors with disadvantaged cost and price. They should divest or incur major efforts to revamp the product market.
Financial characterization: This is a chart that compares industries, companies, or products on profitability versus industry growth. You can determine the attractiveness in investing in industries, companies, or products based on competitive advantage (as measured by relative profitability), industry growth and size of profit or revenue.
X axis is relative growth (How much larger or smaller is the growth of each company or product compared to the industry average growth?).
Y axis is relative profitability (How much larger or smaller is the profitability of the company or product compared to the industry average profitability?).
Z axis or size of bubble measures the total profitability or revenues of each company or product.
Look for the following as you view the chart:
The northeast quadrant has companies or products with profitability and growth. They should invest and grow.
The southeast quadrant has companies or products with negative profitability, but they are growing. They should increase the price or lower the price to grow volume and reduce unit cost.
The northwest quadrant has companies or products that are profitable, but with low growth. These are cash cows where you should harvest the available profits, but do not invest or grow.
The southwest quadrant has companies or products with negative profitability and low or negative growth. They should divest or incur major efforts to revamp the company or product.
Supply chain outsourcing country analysis: This is used to determine which country should be considered as a source country from which to manufacture goods to be imported to the US. This specific example is for a labor-intensive product production that has a need for significant export infrastructure requirements:
X axis is relative cost of country labor (How much larger or smaller is the cost of labor of each country compared to the world average cost? Lowest cost to the right side of the axis and the highest cost to the left of the axis scale).
Y axis is relative political stability (highest stability countries at the top, the average at the midpoint, and lowest stability countries at the bottom).
Z axis or size of bubble measures the total export revenues of each country as a measure of in place infrastructure capable of moving export goods.
Look for the following as you view the chart:
The northeast quadrant has countries with advantaged labor cost and political stability. They are the best candidates today, but as political stability improves, the labor cost normally grows, so they may not be the best long-term choice if you have to invest significant capital costs.
The southeast quadrant has competitors with advantaged labor cost and disadvantaged political stability. These are countries that could be a good long-term choice for capital investment if the political stability is close to the average and improving. They could still have decades of low cost labor available. It is also necessary that the bubble size be large enough to indicate adequate export infrastructure.
The northwest quadrant has countries with advantaged political stability and disadvantaged labor cost. These countries should only be used if there are no countries in the NE quadrant and no countries near the y midpoint with improving political stability in the SE quadrant.
The southwest quadrant has counties with disadvantaged labor costs and unstable political situations. These countries should not be considered as import partners.
This content is provided to you freely by Ensign College.
Access it online or download it at https://ensign.edtechbooks.org/projectbased_internships/bubble_chart.
