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.