Charting every 5th line of data in excel.

[Guest]

Does anyone know of a macro or other way of charting every 5th line of data in excel? I do not want to delete the data, but I want to chart the entire data and there's too many data points, so I want to chart every 5th line yet keep the total data for reference.

 

[Frank Kabel]

Hi Diane
I would do the following:
- create a helper range for charting
- in row one insert the formula
=OFFSET($A$1,(ROW()-1)*5,0)
and copy this down to create a helper range with every 5th column
- use this helper column as chart source

--
Regards
Frank Kabel
Frankfurt, Germany

Does anyone know of a macro or other way of charting every 5th line

of data in excel? I do not want to delete the data, but I want to
chart the entire data and there's too many data points, so I want to
chart every 5th line yet keep the total data for reference.

 

[Bernard V Liengme]

Hi Diane,
Let's say you Y-v alues are in B2:B2000. If C is already used, insert a new
C column.
In C2 =IF(MOD(ROW(B2),5)=0,B2 ,NA()) and copy down to C2000
Every fifth row will display same value as in column B, the rest will show
NA() which will not alter you chart.
You can experiment with varying N in =IF(MOD(ROW(B2)+N,5)=0,B2 ,NA()) to
suit your needs
Best wishes
Bernard

Does anyone know of a macro or other way of charting every 5th line of

data in excel? I do not want to delete the data, but I want to chart the
entire data and there's too many data points, so I want to chart every 5th
line yet keep the total data for reference.