Chart Every Other Column

  • Thread starter Thread starter MABeatty
  • Start date Start date
M

MABeatty

How can I chart every other column in a line chart. I was charting by
manually selecting each value, but aparently this list got too big.
 
I will assume row 1 has labels; x-data is in A2:A100, y-data in B2:B100
Copy label from B1 to C1
In C2 enter =IF(MOD(ROW(),2)=1,B2,NA()) and copy down to C100 (quick way is
to double click C2's fill handle)
Select A1:A100; hold CTRL and select C1:C100
Make chart

The formula above plots the 2nd, 4th, 6th item; to plot 1st, 3rd, 5th use
=IF(MOD(ROW(),2)=0,B2,NA())
bestir wishes
 
Sorry - I always have data in columns while you are using rows.
I will assume:
a) column 1 has headers (labels)
b) x-values are in B1:Z1 (or further)
c) first y-values are in B2:Z2
d) second y-values in B3:Z3

Copy A1:Z1 to row 5
Copy labels A2:A3 to A6:A7
In B2 enter =IF(MOD(COLUMN(),2)=0,B2,NA())
Copy this across to Z2
Copy B2:Z2 down to B3:Z3
Select A5:Z3 and make chart
best wishes
 
Back
Top