Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
two flavors of formatting patterns (border/area vs. line/marker)
Earl,
thanks for replying no, I am doing Format Legend Key - I can email snapshots (did not know how to post images in groups) when I do Format Data Series I have same flavor of the Patterns: line/ marker while I need border/area... john On Nov 9, 3:42 pm, "Earl Kiosterud" wrote: 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 Kiosterudwww.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
10 000 Line, every 2 Lines need a border and a open line inbet. e. | Excel Discussion (Misc queries) | |||
Arrow on a line chart as a marker | Charts and Charting in Excel | |||
How can I lock the formatting (patterns) in Excel? | Excel Discussion (Misc queries) | |||
How do I do conditional formatting on number formats not patterns. | Excel Discussion (Misc queries) | |||
Formatting a footer with a top border-line | Excel Discussion (Misc queries) |