View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default two flavors of formatting patterns (border/area vs. line/marker)

John,

Is it possible that you're doing Format Legend instead of Format Legend Key? Try doing it
this way. Select one of the series (click it), then do Format Data Series. Use the
Patterns tab, and select the marker style there.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
wrote in message
ps.com...
I am creating radar chart comparing my new chart with existing chart
(two different excel files on same computer).

On the old chart legend keys displayed as little squares, on the new -
as lines.

When I bring up Format legend Key dialog on the _OLD_ chart, on the
Tab Patterns I see two groups: Border and Area. The Sample shows a
rectangle with colored border.


When I bring up Format legend Key dialog on the _NEW_ chart, on the
Tab Patterns I see another two groups: Line and Marker. The Sample
shows a simply a colored line.

Same difference I see in Patterns Tab for Format Data Series dialog
boxes.

How can I control which Patterns formatting options are presented to
me? I want to able to set legend Keys as squares, not as lines and I
want to use Fill Effects on data series to make the radar chart more
visually appealing, but current formatting options do not show me
Border/Area groups...

any ideas will be appreciated
thanks
john