Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am drawing a bubble chart in Excel 2010.

I would like each bubble to be associated with its (film) name.

What I cannot do is creating only 1 serie for all the films, and formatting its data label as Series Name, because in that case each bubble will have a long list of all the film names along side it.

So currently what I can do is to create 1 serie for 1 film, then select one bubble and format its data label as Series Name, as follows:

enter image description here

The problem now is that I may have many films, so I have to repeat the selecting of the bubble and formatting the data label... Does anyone know how to select all the series by one click, or format their data label by one click?

share|improve this question
    
I could patch up some VBA-code for this or you could use a chart-template - but I would like to know your dataseries-setup first. Could you add, how your dataseries are defined exactly? –  Jook Oct 2 '12 at 11:01

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.