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

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

Hi Andy,

Thanks for your help. This solved my problem but I have one more question. I
tried to insert an image from the below mentioned link (a pin).

http://members.aol.com/%5Fht%5Fa/wiseowlsw/shadows.htm

So when I save this picture to my harddrive and used the module provided by
you the image is loaded as datamarkers but with a border around it.

Is there anyway to show only the icon without the borders. The file
extension is .gif

Thanks in advance,
Mohan

"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

This should remove the markers border.

With ActiveChart.SeriesCollection(1)
.Format.Fill.UserPicture "C:\temp\lmauve.gif"
.MarkerSize = 20
.MarkerForegroundColorIndex = xlColorIndexNone
End With

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mohan Kumar Karunakaran"
wrote in message ...
Hi Andy,

Thanks for your help. This solved my problem but I have one more question.
I
tried to insert an image from the below mentioned link (a pin).

http://members.aol.com/%5Fht%5Fa/wiseowlsw/shadows.htm

So when I save this picture to my harddrive and used the module provided
by
you the image is loaded as datamarkers but with a border around it.

Is there anyway to show only the icon without the borders. The file
extension is .gif

Thanks in advance,
Mohan

"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

That solved my problem Andy.

Many Thanks

"Andy Pope" wrote:

This should remove the markers border.

With ActiveChart.SeriesCollection(1)
.Format.Fill.UserPicture "C:\temp\lmauve.gif"
.MarkerSize = 20
.MarkerForegroundColorIndex = xlColorIndexNone
End With

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Mohan Kumar Karunakaran"
wrote in message ...
Hi Andy,

Thanks for your help. This solved my problem but I have one more question.
I
tried to insert an image from the below mentioned link (a pin).

http://members.aol.com/%5Fht%5Fa/wiseowlsw/shadows.htm

So when I save this picture to my harddrive and used the module provided
by
you the image is loaded as datamarkers but with a border around it.

Is there anyway to show only the icon without the borders. The file
extension is .gif

Thanks in advance,
Mohan

"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

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

On Thu, 21 Aug 2008, in microsoft.public.excel.charting,
karl said:
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).

I just use Data Labels. You can use the normal numbers in ordinary
fonts, or find the fonts which give numbers in circles or bullets, and
use the characters from those fonts. Format their alignment to
Center/Center, and then format the data series to have no conventional
marker.

No VBA programming required, but it's easier if you download and install
one of the two common free data label add-ins:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

You can simplify this by naming the series '1', '2', etc., and assigning the
default series name data labels.

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


"Del Cotter" wrote in message
...
On Thu, 21 Aug 2008, in microsoft.public.excel.charting,
karl said:
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).

I just use Data Labels. You can use the normal numbers in ordinary fonts,
or find the fonts which give numbers in circles or bullets, and use the
characters from those fonts. Format their alignment to Center/Center, and
then format the data series to have no conventional marker.

No VBA programming required, but it's easier if you download and install
one of the two common free data label add-ins:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

On Fri, 22 Aug 2008, in microsoft.public.excel.charting,
Jon Peltier said:
You can simplify this by naming the series '1', '2', etc., and assigning the
default series name data labels.

I forgot that's one of the genuine improvements in 2007. In 2003 or
below I use my method.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.