Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 made a bubble chart in Excel but can't figure out how you show the user what the size of the bubble means!

The Y and X axes have labels but what about the size of the bubbles?

alt text

Update: as of now, it seems the answer is "you cannot", but if anyone thinks it is possible, please let me know how.

share|improve this question

migrated from Nov 1 '10 at 12:37

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

If you right-click on the chart, you will see an option for Chart Options. Most of these are also available as you walk thru the chart wizard. Personally, I would either add a label as the chart title or as one of the axis desriptions detailing what each point means.

There are some guidelines for using bubble charts here

It seems that most bubble charts are for financial data, so the correlation of the size of the bubble generally relates to the total % that the data point takes up in the series.

share|improve this answer

Turn on data labels (to show X or Y) then right click on the data label to "Format Data Labels..." Label options then appear that allow you to change what the label contains (i.e. change it to show bubble size)

share|improve this answer

Your Answer


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.