Ah, but you can copy an autoshape and paste it onto the bubble series as a
custom marker, and the custom marker will size according to the bubble size
data:

http://peltiertech.com/Excel/ChartsH...omMarkers.html (bubble chart
near the end)

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


"Tushar Mehta" wrote in message
om...
In article ,
?B?
VGltIEg=?= <Tim says...
Is there a way to overlay a scatter plot chart on the same graph as a
bubble
chart? I'm currently using Excel 2002 and I can't get it to combine ANY
other chart type with a bubble chart. Will Excel 2007 allow me to do
this?

No, unfortunately, 2007 doesn't add that capability.

However, it is almost trivial to combine XY Scatter and Bubble charts
(with
one constraint). After all, a Bubble chart is nothing but a XY Scatter
chart with an added dimension.

So, plot your Bubble chart. Then, add an additional column of data for
the
XY chart (assuming that the data are in columns) with all values equal to
some small number. This number will depend on the values in the column
for
the true bubbles but start with 1.

Add this new data set (with 3 columns) to the chart. Change the values in
the dummy column added above to get the desired effect of size.

The constraint on the above technique is that the only kind of 'marker'
you
can use is a circle. You can change the size, the color, and the fill,
the
border, etc., but you are restricted to a circular marker.

--
Regards,

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