Chart Every Other Column
 

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.


--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=553705

Chart Every Other Column
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MABeatty" wrote in
message ...

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.


--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile:
http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=553705