Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubble Chart Plotting
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 -- stephenclark ------------------------------------------------------------------------ stephenclark's Profile: http://www.excelforum.com/member.php...o&userid=30318 View this thread: http://www.excelforum.com/showthread...hreadid=499831 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i add text labels to each bubble on bubble chart? | Charts and Charting in Excel | |||
customizing the mouse-over display in a bubble chart | Charts and Charting in Excel | |||
ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel | |||
Prevent non-numerical data (e.g. text) from plotting on a chart | Charts and Charting in Excel | |||
How do I move a hidden bubble to the front in a bubble chart in E. | Excel Discussion (Misc queries) |