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.