|
I made a bubble chart in excel, but I can't figure out how you show the user what the size of the bubble mean! The Y and X axis have a label, but what about the size of the bubble?
Update: as of now, it seems the answer is "you cannot", but if anyone thinks it is possible, please let me know how.
| ||||
|
feedback
|
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 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. | |||
|
feedback
|
