How can i plot every 10 of my data points (i.e. 1, 11,21,.,10001)

V

volk

i have a huge data. therefore i want to make plot using one point for every
10 data (i.e. 1,11,21,31,...,90001). Is it possible to do it just by
manupulating the" x values" or "y values" line in the source data window?
 
D

David Biddulph

volk said:
i have a huge data. therefore i want to make plot using one point for every
10 data (i.e. 1,11,21,31,...,90001). Is it possible to do it just by
manupulating the" x values" or "y values" line in the source data window?
Click to expand...

One way is to produce a helper column with the formula =MOD(ROW(),10)
and then filter choosing 1 in that column.
 
B

Bernard Liengme

No need for filter.
Let your x-values be in A2:A101, y-values in B2:B101
In C2 enter =IF(MOD(ROW(),10)=,B2,NA())
Copy down the column
Select A1:A101; hold CTRL key; select C1:C101 and start chart wizard
This plots 10th, 20th, 30th data points; all the N/A values are ignored in
the chart.
best wishes
 
Top