Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 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
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .