Swapping data between columns

F

Fan924

Swapping data between columns C & D quickly. C is linked to charts. I
would like to be able to switch effertlesly between C & D and study
the charts. Can columns be renamed?
 
B

Bernie Deitrick

Set up your chart data area with the formulas in the Y area of:

=INDEX($C:$D,ROW(),$A$1)

and then enter a 1 into cell A1 to show the data from C, and enter a 2 in A1 to show data from D.

HTH,
Bernie
MS Excel MVP
 
Top