Apologies for asking a question in a reply (every time I try to start a new
thread I get nothing but a blocked pop up!)
I want to replace the markers in 2000 excel scatterplot charts with numbers
so for a given object I can identify its attributes across a number of
scatterplots.ie all the ones correspond to the first object, all the two's to
the second etc.is this possible and if it is how (keep in mind I'm just a
biologist not a programmer). Could I do it as per the Andy Pope instructions?
is there an easier way?
Thank-you for your consideration
--
karl
"Andy Pope" wrote:
Hi,
Create a line chart with 2 series. Then with the chart selected run this
routine.
Make sure you change the UserPicture filename to one that is on your system.
Sub MyMarkers()
' from file
With ActiveChart.SeriesCollection(1)
.Format.Fill.UserPicture "C:\Waterfall.jpg"
.MarkerSize = 20
End With
' from shape on worksheet
With ActiveChart.SeriesCollection(2)
ActiveSheet.Shapes("Picture 1").Copy
.Paste
End With
End Sub
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mohan Kumar Karunakaran"
wrote in message ...
Hi,
I would like to add some pictures as data markers in my line chart using
excel VBA. I tried recording a macro to do this but the code is not
generated
for the insert picture part. Does any one have an idea for this.
Regards,
Mohan