Ask Your Question

Count values for bubble sizes?

asked 2017-11-24 16:54:27 +0200

aditsu gravatar image

I made a simple bubble chart, I don't have enough points to upload it here, so you can get it from this location instead.

What I would like to get is to have each bubble size proportional to the number of values appearing at that exact point. So it should look exactly the same as in the example, but without requiring me to add the C column ("Count") or some kind of pivot table; it should just do it automatically. Notice that there are 2 points with X=2 and Y=4, so that bubble should be twice as big as the other ones. Is it possible to do that in LibreOffice?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-11-24 20:32:51 +0200

Jim K gravatar image

updated 2017-11-24 21:01:34 +0200

Relative bubble sizes must be specified in a cell range. So keep the "Count" column, but calculate it automatically. To do this, enter =SUMPRODUCT(A$2:A$6=A2;B$2:B$6=B2) in C2 and then drag to fill down to C6.

After that, you may want to remove duplicate rows. This would give a chart with only one point in each location, rather than plotting multiple identical points in the same location.

Documentation: SUMPRODUCT.

edit flag offensive delete link more


Thanks, I was hoping for a more automatic way to do this, but I guess it's not possible currently. The SUMPRODUCT tip is interesting though.

aditsu gravatar imageaditsu ( 2017-11-26 14:28:21 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-24 16:54:27 +0200

Seen: 102 times

Last updated: Nov 24 '17