Microsoft's Excel software is one of the best tools for you to organize, analyze, and manipulate data. Here are three ways to compare data in two columns.

The Cluster Column option is the left-most option of each of the column types, such as 2-D, 3-D or Cylinder. The cluster column chart is automatically created by Excel on the same page as your data.

By selecting all three columns of data, you can select the type of chart from Excel's Insert tab. The most useful selection is a bar chart, because it allows you to format the second series as a line.

1. Open Microsoft Excel on your PC or Mac computer. 2. Select the column to the right of where you want a new column. (Excel will insert the new column directly in front of it.) ...

3. Selecting a cell that's below the first row will also freeze all prior rows. For example, if you select cell D5, you will freeze columns A, B and C; as well as rows 1, 2, 3 and 4. 4.