Bubble charts cannot be combined with other chart types, so you can't
use the obvious Scatter chart techniques for drawing in lines. So if you
can't get the scatter chart into the bubble chart, bring the bubbles to
a scatter chart.
You can borrow some VBA code from Microsoft. KB article 139662 was
written to address the apparent inability to make a true bubble chart
using VBA. The macro recorder sets the chart type before setting the
source data range, but some chart types need you to do these steps in
the reverse order. I guess the techie who wrote the article didn't know
that, so they posted a workaround that draws a circle (a drawing object
independent of the chart) for each point, sized accordingly, then
applies the circle to the point as a custom marker.
The article's at:
http://support.microsoft.com/default.aspx?scid=kb;[LN];139662
Make the scatter chart with the diagonal lines, then add the series with
any markers at the XY coordinates for the bubbles, then use an
adaptation of the macro to draw the bubbles. You can change the colors
and shapes of the custom marker, too: use a square or triangle instead
of a boring old circle.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
