how to create bubble chart ?

Hi there

With the attached excel sample, how can i create a bubble chart as in the link example?

http://www.trademap.org/Country_SelProductCountry_Graph.aspx?nvpm=1|156||||07|||2|1|1|2|1|1|2|1|1


Thanks!

Originally Posted by MrShorty

Here's a basic introduction to creating bubble charts: https://support.office.com/en-us/art...1-c766f3e330d9 There are three quantities that go into bubble charts
1) the X values -- your picture shows "% share of partner countries" as the x values, but I do not see this quantity anywhere in the spreadsheet.
2) the Y values -- your picture shows "% growth", which I can see in your table.
3) the bubble size values -- I cannot tell from your picture or your spreadsheet what value determines bubble size.

Figure out what those quantities should be, then compute them in the spreadsheet.

With a bubble chart, it will probably be easiest if these quantities are in three adjacent columns with the x values in the left column, the y values in the middle column, and the bubble size values in the right column. This is the arrangement Excel will be looking for when you create the bubble chart. If you really don't want to arrange the columns this way, then you can "fix" Excel's default choices after chart creation through the Select Data dialog.

Does that help?

Hi MrShorty,

Still cant get it right, pls see if the bubble size values correct?

Originally Posted by MrShorty

Going into the Select Data dialog (2010 help file: https://support.office.com/en-us/art...angesourcedata ), it appears the the bubble size field for each data series is the array constant {1,1,1...}. Reading the heading on your table, it appears that you intended for column C to be in the bubble size field. Which is your intention? Fixing this should be as easy as entering the Select Data dialog and editing each data series until each field refers to the correct column in the spreadsheet. If I understand your column headers, I would expect you want column E to be the X values, column D to be the Y values, and column C to be the bubble values.

Does that help?

Hi MrShorty,

Thanks, i think the chart made sense now.