Wrapping text in embedded MSGraph

[John Svendsen]

Hi All,

I don't know if this is the right newsgroup to post to, but I need to wrap
long text in an embedded MSGraph's category axis (line graphs with text
explaining on the bottom axis).

I have inserted (via VBA) a "chr(10)" at the place to wrap the text, but the
text isn't wrapped

this is the bit of the VBA code:

If InStr(.Cells(1, lCol), sFirst) > 0 Then
.Cells(1, lCol) = Replace(.Cells(1, lCol), sFirst, sLast)
End If

Is there a way to set the cell to wrap ?

Thanks, JS