View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Bubble Chart Plotting

Stephen -

Excel does not have the capability to make bubbles with different height and
width values. You can make the ellipses by hand (or using VBA), and apply
them as custom markers to points in an XY, Line, or Bubble chart (I'd shy
away from the Bubble, since you're already making custom markers). Do this
by copying the shape, selecting the whole series (one single click) or point
(two single clicks) and pasting. Details can be found he

http://peltiertech.com/Excel/ChartsH...omMarkers.html

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


"stephenclark"
wrote in message
news:stephenclark.21fj8b_1136914504.8352@excelforu m-nospam.com...

I am having a problem creating a bubble chart in excel 2000. I am trying
to create a tool for managing projects.
The problem I have is that I cannot get excel to create the bubbles as
an ellipse. (x-duration) and (y-magnitude). It seems that it is only
capable of making circles. Is there anyway around this problem.
Any advice would be greatly appreciated.

Thanks
Stephen Clark