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:

enter image description here

At the moment, the legends are all situated on the right of the chart. In Excel 2003, it is possible to put them along side each bubble, it seems that in Excel 2010 this option has disappeared.

But I think it is clearer to have legend associated to each bubble, does anyone know how to realize that?

share|improve this question

migrated from stackoverflow.com Oct 1 '12 at 11:22

This question came from our site for professional and enthusiast programmers.

    
For future reference this is better suited to Super USer –  brettdj Sep 29 '12 at 11:52
add comment

1 Answer

up vote 1 down vote accepted

The Legend is the list of different series in the chart. It is usually on the right side of the chart.

What you want to do is add Data Labels to the points on the chart:

  • right click your bubbles
  • Add Data Labels
  • right click your data lables, Format Data Labels
  • check Series Name

repeat for each Series

enter image description here

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.