Thread: skip data points in graph

If I want to plot a x-y graph in Excel with 100 data points, is it possible
to have Excel automatically pick every 10th point (for example). I know I
can manually choose every 10th point, but can Excel do it just by clicking a
box or something?

Ayesha

since excel only plots visible cells
use a filter to select and show only evey tenth row.

"Ayesha" wrote:

> If I want to plot a x-y graph in Excel with 100 data points, is it possible
> to have Excel automatically pick every 10th point (for example). I know I
> can manually choose every 10th point, but can Excel do it just by clicking a
> box or something?
>
> Ayesha

Hi BJ,

Didnt try, was just wondering.

Can one use such an array formulas which would return only every 10th
address and pass this result in to the series formula.

Thanks a lot,
Hari
India

"bj" <bj@discussions.microsoft.com> wrote in message
news:EC20CBB0-80AF-473F-8881-C476F1918543@microsoft.com...
> since excel only plots visible cells
> use a filter to select and show only evey tenth row.
>
> "Ayesha" wrote:
>
>> If I want to plot a x-y graph in Excel with 100 data points, is it
>> possible
>> to have Excel automatically pick every 10th point (for example). I know
>> I
>> can manually choose every 10th point, but can Excel do it just by
>> clicking a
>> box or something?
>>
>> Ayesha

if you are going to use a different data set
you could use something like
(if your data were say in B21 to B221
enter in G1)
=indirect("B"&(21+(Row()-1)*10))
and copy down to G21
this would give you a set of the data points form every 10 positions

I am nor sure of an Array formula which would do it for you.

"Hari Prasadh" wrote:

> Hi BJ,
>
> Didnt try, was just wondering.
>
> Can one use such an array formulas which would return only every 10th
> address and pass this result in to the series formula.
>
> Thanks a lot,
> Hari
> India
>
> "bj" <bj@discussions.microsoft.com> wrote in message
> news:EC20CBB0-80AF-473F-8881-C476F1918543@microsoft.com...
> > since excel only plots visible cells
> > use a filter to select and show only evey tenth row.
> >
> > "Ayesha" wrote:
> >
> >> If I want to plot a x-y graph in Excel with 100 data points, is it
> >> possible
> >> to have Excel automatically pick every 10th point (for example). I know
> >> I
> >> can manually choose every 10th point, but can Excel do it just by
> >> clicking a
> >> box or something?
> >>
> >> Ayesha
>
>
>

An array formula could work, but I don't have time to think of an example.

The Microsoft Excel Charting FAQs has more on decimating data:

http://pubs.logicalexpressions.com/P...?ID=209#jon024

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


bj wrote:

> if you are going to use a different data set
> you could use something like
> (if your data were say in B21 to B221
> enter in G1)
> =indirect("B"&(21+(Row()-1)*10))
> and copy down to G21
> this would give you a set of the data points form every 10 positions
>
> I am nor sure of an Array formula which would do it for you.
>
> "Hari Prasadh" wrote:
>
>
>>Hi BJ,
>>
>>Didnt try, was just wondering.
>>
>>Can one use such an array formulas which would return only every 10th
>>address and pass this result in to the series formula.
>>
>>Thanks a lot,
>>Hari
>>India
>>
>>"bj" <bj@discussions.microsoft.com> wrote in message
>>news:EC20CBB0-80AF-473F-8881-C476F1918543@microsoft.com...
>>
>>>since excel only plots visible cells
>>>use a filter to select and show only evey tenth row.
>>>
>>>"Ayesha" wrote:
>>>
>>>
>>>>If I want to plot a x-y graph in Excel with 100 data points, is it
>>>>possible
>>>>to have Excel automatically pick every 10th point (for example). I know
>>>>I
>>>>can manually choose every 10th point, but can Excel do it just by
>>>>clicking a
>>>>box or something?
>>>>
>>>>Ayesha
>>
>>
>>

Sorry, how do I do that? Using the "advanced filter" option? How do I set
it up to up every 10th row?

Ayesha

"bj" wrote:

> since excel only plots visible cells
> use a filter to select and show only evey tenth row.
>
> "Ayesha" wrote:
>
> > If I want to plot a x-y graph in Excel with 100 data points, is it possible
> > to have Excel automatically pick every 10th point (for example). I know I
> > can manually choose every 10th point, but can Excel do it just by clicking a
> > box or something?
> >
> > Ayesha