Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Swapping data between columns
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Swapping data between columns
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Swapping Columns | Excel Discussion (Misc queries) | |||
Swapping columns | Excel Programming | |||
swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
swapping columns?? | Excel Discussion (Misc queries) |