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 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 stackoverflow.com Nov 1 '10 at 12:37

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

1 Answer 1

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

http://office.microsoft.com/en-us/excel/HA011170761033.aspx?pid=CL100570551033

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

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.