Excel 2003 Markers
I have a request to chart data where I only want to display a marker every n
points, but still see the marker in the Legend.
I can do it by setting the MarkerStyle to a value, then go through every
point in the series and change it's markerstyle to xlNone. However, when
there are 1000's of datapoints per series, this takes a long time.
I can set the MarkerStyle to xlNone, then go through setting every nth point
to a marker, but then the MarkerStyle doesn't show up in the legend.
I can't seem to set the MarkerStyle in the LegendKey without affecting all
the points in a series.
Does anyone have a way I could see the Marker in the Legend Key, but only
have the marker visible for every Nth point, without having to iterate
through every point in every series?
Thanks,
Bob
|