HI

I need to plot a diagonal in a bubble chart. It is dynamically generated
otherwise I'd simply manually draw the line! As you can't (I think) use two
chart types with bubble charts, generating a line drawing object seem the
best approach. What I'd like to do is to generate a drawing object that
takes its co-ordinates from a series on the chart.
SO, if I draw it manually and record a macro I get:

ActiveChart.Shapes.AddLine(210#, 55.5, 277.5, 540#)

I need to replace the absolute values with ones generated by a data series.
At the moment the best I can do is generate very small bubbles to form a
slightly surreal diagonal of dots through the chart, but what I really need
is a clean line that goes to the edge of the chart.

I'm sure I haven't expressed this very well but any help in matching data
series co-ordinates and drawing object co-ordinates would be much
appreciated.

Thanks

Matthew de Gale