Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Marker option for Excel XY charts

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).
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 108
Default Marker option for Excel XY charts

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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Marker option for Excel XY charts

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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 120
Default Marker option for Excel XY charts

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/ChartsH...omMarkers.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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Marker fill option not retained. Raghavendra Charts and Charting in Excel 0 July 26th 09 04:31 AM
Graphic Data Marker in Excel 2007 Charts Mohan Kumar Karunakaran Charts and Charting in Excel 11 August 23rd 08 03:23 AM
option buttons on charts TLCN Charts and Charting in Excel 3 October 9th 07 11:18 PM
Excel Charts with attached comments option Neils Charts and Charting in Excel 3 March 16th 06 09:35 PM
Transparency graphic option not working on Excel Charts? Charles Charts and Charting in Excel 1 February 13th 06 09:47 PM


All times are GMT +1. The time now is 04:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"