Plot every 10th pt

[Jeff]

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

[Bernard Liengme]

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" <[email protected]> wrote in message
news:[email protected]...
> 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