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


"Fan924" wrote in message
...
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?