Bubble grid chart y axis text

[Tom83]

Hi all,

I have created a bubble grid chart and want to get the description (countries) on the Y axis, is this possible?

Thanks!

 

[Tom83]

Hi all,

I have created a bubble grid chart and want to get the description (countries) on the Y axis, is this possible?

Thanks!

View attachment 38698

Ps of course I tried to put the countries in the first column but this breaks the graph because it’s a value axis

 

[RoryA]

You can plot an additional data series with X values set to {0,0,0}, Y values set to {1,2,3} and bubble size set to {1,1,1}. Then add data labels, positioned to the left, to that series using the 'Values from cells' option to assign the country names. Then set the fill for that series to None, and remove the existing axis labels.

 

[Tom83]

You can plot an additional data series with X values set to {0,0,0}, Y values set to {1,2,3} and bubble size set to {1,1,1}. Then add data labels, positioned to the left, to that series using the 'Values from cells' option to assign the country names. Then set the fill for that series to None, and remove the existing axis labels.

Thanks, I understand the trick. I didn't get it working though, nothing is presented in the graph for the second dummy series. And it's not the formatting, this is still in color...

 

[RoryA]

Sorry - overlooked the fact that you are using years. Set the X values to {2018\2018\2018} (and amend the bubble size values as you only need 3 entries)

 

[Tom83]

Sorry - overlooked the fact that you are using years. Set the X values to {2018\2018\2018} (and amend the bubble size values as you only need 3 entries)

Great, that does the trick at least for a certain part. For some reason {1,2,3} in Y axis and {2018\2018\2018} for X axis is not accepted, it gives an error. Also with = before it or using ; or , in between. I solved it by referencing to B24 and it shows Germany now, what goes wrong with the other countries not showing?

 

[RoryA]

Given what it has accepted for the Y values, ={2018\2018\2018} should work for the X values. The bubble sizes should only be: ={1\1\1}

 

[Tom83]

Given what it has accepted for the Y values, ={2018\2018\2018} should work for the X values. The bubble sizes should only be: ={1\1\1}

Got it! Thanks for the help!