LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
John
 
Posts: n/a
Default XY Scatter Legend when Edit Individual Markers

Usually, I have to chart alot of data. I cannot really use color to
distinguish the line and the line styles leave alot to be desired when the
points are close together. Therefore, I use the symbols to better
distinguish the data series. However, with alot of data the symbols make the
lines just appear fat, again making it difficult to distinguish the line.
Therefore, I loop through the points and set the individual point markers at
a different frequency for each series. This works great. However, the
legend doesn't display the markers. The first point on every data series
always has a marker. Is there a way to change what the Legend displays wrt
symbols?

Because I do the symbol addition programmatically the first data series on a
chart always has the same look. However, when there is only one series on
the chart the legend changes to show a list of xlCategory values for the
points with the line and symbol style next to them. I need the legend
because the titles are generic for a group of about 50 charts. Is there a
way to prevent this behavior?

XMGR is sooooo much easier at plotting alot of data.

Thanks,
John
 
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
loop trough e-mail address list to send task lists with outlook Paul. Excel Discussion (Misc queries) 2 April 14th 05 11:48 AM


All times are GMT +1. The time now is 09:02 AM.

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

About Us

"It's about Microsoft Excel"