Need help to create a bubble chart

**excel_clueless1996** · 08-02-2019, 06:18 PM

Hi,

I have some analysis work to do to quantify trends by how often they are mentioned. I want to do this by creating a bubble chart, each bubble representing one trend and the size of each bubble, quantifying the number of times it is mentioned (identified 4 trends in total). I want to bucket the mentions of the trends in 4 buckets. Would it be possible to create a 4 quadrant bubble chart, each representing each bucket, and have the bubble chart in each quadrant representing the trends.

Hence 4 quadrants with 4 bubbles of varying size in each, representing each trend.

Is this possible?

**MrShorty** · 08-02-2019, 07:02 PM

Short but useless answer -- yes this is possible.

Is there a specific part of creating a bubble chart that you are uncertain about?

A bubble chart in Excel is kind of like a scatter chart, in that both the horizontal x axis data and the vertical axis data are treated as numbers. So, a bubble chart will usually involve three columns (rows) of data: one column (usually the left column) for the horizontal position, a second column (usually middle) for the vertical position, and a third column (usually right) for the bubble size:

Please Login or Register  to view this content.

Select the three data columns -> insert chart -> bubble chart. Check that Excel interpreted the data series correctly. If you use this sample data, you should have a bubble chart with 4 bubbles, one in each of the four quadrants of the chart (assuming Excel defaults to "axes cross at 0"). Expand on that as much as needed.