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?
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?
"volk" <[email protected]> wrote in message
news:[email protected]...
>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?
One way is to produce a helper column with the formula =MOD(ROW(),10)
and then filter choosing 1 in that column.
--
David Biddulph
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"volk" <[email protected]> wrote in message
news:[email protected]...
>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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks