Charting every 5th line of data in excel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
Diane said:
Does anyone know of a macro or other way of charting every 5th line
Click to expand...
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.
 
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

Diane said:
Does anyone know of a macro or other way of charting every 5th line of
Click to expand...
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.
 
Back
Top