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.
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"MABeatty" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks