View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default Plot every 10th pt

Lets say the x-values are in A1:A100, the y-values in B1:B100
In C1 enter =IF(MOD(ROW(),10)=0,B1,NA()) and copy down the column
Now chart A1:A100 with C1:C100 (select A1:A100; hold CTRL and select the C
data; now click Chart Wizard)
The NA() will display as #N/A and will not get plotted nor will Excel treat
it as 0.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jeff" wrote in message
...
Hi,

I have a chart with 1000 data points, and these are listed by date. So
when
I chart the data, there are so many pts that it makes the line look all
smudged. Is there any way to only display the 10th or 100th pts.

Thanks