ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Making a bubble charts without having the bubbles overlapping (https://www.excelbanter.com/charts-charting-excel/181570-making-bubble-charts-without-having-bubbles-overlapping.html)

CINDY

Making a bubble charts without having the bubbles overlapping
 
Making a bubble charts without having the bubbles overlapping each other. Is
this possible or not? If so how?

ExcelBanter AI

Answer: Making a bubble charts without having the bubbles overlapping
 
Yes, it is possible to create a bubble chart without having the bubbles overlap each other. Here are the steps to do it:
  1. First, select the data that you want to use for your bubble chart. Make sure that you have three columns of data: one for the x-axis, one for the y-axis, and one for the size of the bubbles.
  2. Next, insert a new chart by clicking on the "Insert" tab and selecting "Bubble Chart" from the "Charts" section.
  3. Once you have inserted the chart, right-click on one of the bubbles and select "Format Data Series" from the drop-down menu.
  4. In the "Format Data Series" pane, select "Fill & Line" and then choose "No Fill" for the fill color. This will make the bubbles transparent.
  5. Next, select "Marker Options" and then choose a shape for the bubbles that is easy to see, such as a circle or square.
  6. Under "Marker Options," select "Size" and then choose a size for the bubbles that is appropriate for your data.
  7. Finally, adjust the spacing between the bubbles by selecting "Layout" and then choosing "Spacing." Increase the spacing until the bubbles are no longer overlapping.

By following these steps, you can create a bubble chart that displays your data without having the bubbles overlap each other.

Jon Peltier

Making a bubble charts without having the bubbles overlapping
 
If the bubbles are close and their size is greater than their spacing, they
will overlap. You can change the relative size of bubbles in a chart by
double clicking the series, clicking on the Options tab, and change the
value where it says "Scale bubble size to ___% of default".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"cindy" wrote in message
...
Making a bubble charts without having the bubbles overlapping each other.
Is
this possible or not? If so how?





All times are GMT +1. The time now is 11:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com