Menu
I create a bubble chart using google-charts. It seems like this:
Here the data that i use:
My Question is How I change the size of bubbles so they will be like the column:"bubble size" that in the table? And how can i make the X-axis be more wider?
443
Note that you can change the bubble size by selecting any bubble and dragging its handle.
Go to the Set-up tab and select Chart Type from the drop-down arrow. Select the second option, Bubble, from the Scatter Chart drop-down menu. Replace the bar chart with bubble chart in Google Sheets. Go to the Customize option in the chart editor and edit and format your Bubble Chart.
In Microsoft Excel's bubble charts, bubble sizes are fixed according to the largest bubble in the chart. You can fine tune this maximum size by double clicking on any series, and on the Format Series dialog, Options tab, select a default multiplier. I like to use 200% to get large bubbles.
According to the docs, it seems the 5th column should control the size of the bubble. And the 4th should be an ID (I'd use the country's code for this, or just repeat the counytry col again).
80
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
