Thanks for the response.

The solution is too bulky for my needs. I cannot afford to do it
programatically for as many charts I could have.

John

"Bernard Liengme" wrote:

> The solution is to use another data series with sparse data.
> Lets say your x-values are in A1:A1000, y-values in B1:B1000
> In C1 enter =IF(MOD(ROW(),50)=1, B1, NA()); copy down to C1000
> This displays column B values fro every 50th row and #N/A for those in
> between.
> Select A1:C1000 and make plot
> Format B values as Line only and C values as markers only
> Remove legend for B series
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "John" <John@discussions.microsoft.com> wrote in message
> news:884C4771-AB67-4386-863A-CF5BA8393D28@microsoft.com...
> > 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
>
>
>