View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
denzel denzel is offline
external usenet poster
 
Posts: 2
Default Too many markers on line chart makes it a thick line and individual markers cannot be seen

I have lots of data to be plotted and when I choose a marker to be
displayed, the resultant line just looks like a thicker line. You can't
individually pick out the marker being used. Without messing with the input
data, is there any way to get Excel to place a marker every 10th or 20th
data point instead of every data point?

I still want the line to plot the entire data. And I don't want to have to
manipulate my source data. If I only plot every 10th data point, I may miss
peaks that occur between the 10th points. And it's too cumbersome to pick
the data by hand out of the hundreds of data points.

I want to continue to use markers instead of colors or dashed lines to
differential my graphed lines.

Smaller symbols won't help since the data is so closely plotted together.

Is there some easy solution to this?

Thanks.