Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 130
Default 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?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
displaying hidden/smaller bubbles on a bubble chart kalan Charts and Charting in Excel 1 September 14th 06 11:16 AM
How do I name the Bubbles on my Bubble chart. Larry B. Charts and Charting in Excel 1 February 10th 06 07:05 PM
Can I keep the bubbles in my bubble chart from overlapping? B_Gr Charts and Charting in Excel 1 May 21st 05 05:56 PM
want to make a bubble graph with 20 bubbles and gradient coloring. dstout Charts and Charting in Excel 1 March 16th 05 03:55 PM
How do i "bring to front" bubbles in excel bubble charts which ar. Ganesh Charts and Charting in Excel 1 March 10th 05 01:47 PM


All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"