View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Display hidden bubbles

Order the data in each series so the large bubbles are plotted first (higher
in the data list) and small bubbles last. Then order the series so the one
with larger bubbles is plotted first, although this is not as likely to
prevent obscuring of bubbles on the first series.

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


"Richard" wrote in message
...
I have some hidden points on a bubble chart.

How do I prevent bigger bubbles from covering up small bubbles on a bubble
chart?

It would be fine if the smaller bubble partially covered the bigger
bubble.

--
Richard