Non-numeric values in Bubble Charts

[gossip_boi]

Dear All,

I have a question. Being inspired by this article http://chandoo.org/wp/2015/09/22/how-countries-spend-their-money/ I created smth similar to the original chart. Please, find the file attached. So, you can see that I can't change numeric names into non-numeric values. How can I do it? Here https://sites.google.com/site/e90e50fx/home/matrix-bubble-chart-with-excel the solution was made with class modules but I would like to avoid it.

Thanks a lot for trying to help =)

 

[Chihiro]

Several ways of doing this.

1. Select Data Label that you want to change
2. Go to formula bar and type in value

Alternately you can create helper row/column and add cell reference. Make sure you have =SheetName!$A$1 format for the reference.

You can also use VBA to assign different values/text for datalabels.
Something like below.

ActiveChart.FullSeriesCollection(2).Points(1).DataLabel.Select
    Selection.Formula = "=Bubbles!R4C3"

 

[gossip_boi]

Could you do both ways in the file? I even can't imagine what you mean.

 

[Chihiro]

I forgot about the easier method.

Select Data Label and Right click and choose "Format DataLabel"

Then Check off "Value From Cells" and select desired range.



See attached with sample range/label.

 

[gossip_boi]

Is it possible in Excel 2007?