View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jzurbo77@gmail.com is offline
external usenet poster
 
Posts: 2
Default two flavors of formatting patterns (border/area vs. line/marker)

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