Bubble Graphs

[Strongpauly]

I am having some trouble with bubble graphs. I want to be able to have
line linking each bubble together or some other way to combine a lin
graph with a bubble graph. I have tried using a trend line, but i
doesn't seem to work right, as it works on averages or othe
mathematics rather than actually linking the points. I would rathe
not resort to an overlay because i will have to produce a lot of thes
types of graphs and that would take forever.

Any suggestions???

Thanks S

 

[Tushar Mehta]

I was going to suggest you add a 2nd series to the chart and make that
new series a line chart. Unfortunately, XL (at least 2003) refuses to
mix a line chart with a bubble chart.

So, it would appear you are stuck with overlays. Of course, you may be
able to simplify your work to some degree with a VBA macro.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

It's also 2002, 2000, '97, and earlier versions of Excel which do not
allow combining bubble charts with other charts.

The approach which can be taken in VBA is to plot the series, complete
with lines, then use a custom marker for each point. The marker consists
of a circle which is scaled according to the third value.

Microsoft has a knowledge base article with such a macro here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;139662

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

 

[Strongpauly]

That is clever, but i actually (eventually) found a work around b
creating the lines made up of bubbles with very small sizes. Of cours
this meant i had to make a bubble for each point on the line, but i
works ok.

Thanks guy