Stack Exchange network consists of 174 Q&A communities includingStack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Sign uporlog into customize your list.
Start here for a quick overview of the site
Detailed answers to any questions you might have
Discuss the workings and policies of this site
Learn more about Stack Overflow the company
Learn more about hiring developers or posting ads with us
I made a bubble chart in Excel but cant figure out how you show the user what thesizeof the bubble means!
The Y and X axes have labels but what about the size of the bubbles?
Update: as of now, it seems the answer is you cannot, but if anyone thinks it is possible, please let me know how.
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.
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)
If you right click on data label there is an option toFormat Data Labels. You will need to turn on the data labels to see this.
Where is the bloodiest square mile on Earth?
Im 24 with a 4-year-old son. How to handle uncomfortable questions from people?
Category theory for a set/model theorist
Using \color inside a \parbox causes vertical displacement
Is there an idiom for Your decision can change at the last moment
Making a nail electromagnet with bare copper wire?
What effect would a means of reproduction without pregnancy have on the population?
How can I play the devils advocate in politics without being attacked?
Why arent Americans simply called Americans?
Can Genesyss solar amplifier generate 40kW of power from a 200W solar panel?
Is Palpatines identity a spoiler?
Does damage from an ally break Dominate Person?
Project I was hired for is off the rails due to constantly changing requirements, now its me on the spot
Theory to explain ordering of tribes in Numbers 13
Is there a German equivalent for self defeating?
In HD Wallet recovery how does the wallets know which addresses to recover
If I change the license of my project, can someone use the old license by navigating through git history?
Finding the most efficient paths to cover an area from multiple starting locations
Why can we still breathe in valleys?
Minimum operations to get from one number to another
How can Santa keep his lists when GDPR is around?
Autonumbering and spacing for custom label using enumitem and enumerate
Why am I not dead after repeatedly touching a high-voltage source?
site design / logo 2018 Stack Exchange Inc; user contributions licensed undercc by-sa 3.0withattribution required.rev2018.6.8.30702