ChangeColumnPos(Source, Dest)

Swaps two columns. This method contains the following parameters:

•Source: Index of the column to swap to Dest

•Dest: Index of the column to swap to Source

Example:

Sub CommandButton1_Click()
  Screen.Item("E3Chart1").Legend.ChangeColumnPos 1, 2
End Sub