Prev: How do I change my return to the next row so not always right?
Next: Fixing Image In A Cell
From: N.Kannan on 31 Jan 2010 20:13
I find the choices of marker options for plotting XY-Scatter plots is quite
limited to just 9 characters (like box, triangle, star, +, - etc.,). Is there
a way to utilize Wingdings for more choices? If so, how to do it? I just
learnt how to add 'clip arts' as a marker but I'm more interested in
Wingdings characters that are plenty and a 'font' (not a clip art).
From: Ed Ferrero on 1 Feb 2010 01:02
Hi N.Kannan,

Turn off the gridlines (View Gridlines)
Type a character in a cell
Format to Wingdings font
Change the cell width to about the width of the one character
Copy
Paste as Picture (Home, Paste, Paste as Picture)
Use as marker in your chart

Ed Ferrero
www.edferrero.com
From: N.Kannan on 1 Feb 2010 01:40
Hi N.Kannan,

Turn off the gridlines (View Gridlines)
Type a character in a cell
Format to Wingdings font
Change the cell width to about the width of the one character
Copy
Paste as Picture (Home, Paste, Paste as Picture)
Use as marker in your chart

Ed Ferrero
www.edferrero.com
From: PBezucha on 1 Feb 2010 09:12
It often appears that the assortment of markers offered in scatter charts is
insufficient, especially for scientific purposes, where the custom markers
taken from Wingdings or from drawn shapes
(http://peltiertech.com/Excel/ChartsHowTo/CustomMarkers.html)
are lowbred for serious presentation. Another disadvantage of such an Excel
makeshift against some other applications is that the selected sizes of these
markers are given once for ever, and cannot be reproducibly changed by means
of menu.
There is no problem if one can use colored (hollow) markers, though various
shades of grey may even sometimes help. For black print, however,
circumvention still exists. You can use some of mentioned hollow markers as a
basic series, and then, for the same series of data, use in repetition some
of line markers (+ × * -). You become variously filled hollow shapes. Instead
of basic number of eight (reasonable) markers, you obtain 4 (square, diamond,
circle, triangle) × 6 (4+empty +full) = 24 combinations. Sorry, no
achievement is entirely for nothing. You will sometimes find out that you
must better adapt the sizes of complementing shapes by a unity to fit
perfectly. Similar conjuring can be performed with concentric (same of
different) hollow shapes with (different or same) sizes.
I wonder I have never read a recommendation on this theme, and hope it could
help not only to you.

--
Petr Bezucha


"N.Kannan" wrote:

> Hi N.Kannan,
>
> Turn off the gridlines (View Gridlines)
> Type a character in a cell
> Format to Wingdings font
> Change the cell width to about the width of the one character
> Copy
> Paste as Picture (Home, Paste, Paste as Picture)
> Use as marker in your chart
>
> Ed Ferrero
> www.edferrero.com
 | 
Pages: 1
Prev: How do I change my return to the next row so not always right?
Next: Fixing Image In A Cell